MySQL Tutorial





Español Français 中文 Deutsch Portuguese Japanese nederlands
   
 
Mysql Tutorial
Introduction
How to Install
Database
Datatypes
Tables
INSERT
SELECT
UPDATE
DELETE
Operators
Functions
Ask Your Doubts
Feedback
 





Free MySQL Tutorial

Tutorial Index



How to Install

Windows Install
Linux Install
MAC OS Install

Database

Database Overview
Starting MySQL
Connecting MySQL
Creating Database
Using Database
Removing Database

Datatypes

Introduction
Numeric Datatypes
Date Datatypes
String Datatypes

Tables

Creating Tables
Listing Tables
Deleting Tables
Renaming Tables
Altering Tables
Alter - ADD COLUMN
Alter - DROP COLUMN
Alter - MODIFY COLUMN

INSERT

Insert - Add Row
Insert - Multiple Rows
Auto Increment

SELECT

Counting Rows
Selecting All Datas
Using Limit
Selecting Columns
Sorting Rows
Sorting Multiple Rows
Where Clause
Pattern Matching
Group By Clause

UPDATE

Update Statement

DELETE

Delete Statement

Operators

Operator Precedence
Type Conversion
Logical Operator
Comparison Operator
Arithmetic Operations

Functions

Numeric Functions
String Functions
Date & Time Functions
Feedback

Introduction:

MySQL is the most popular open source SQL database management system (DBMS) developed, distributed, and supported by MySQL AB, a commercial company, founded by the MySQL developers.

It is a Relational Database Management System (RDBMS) and it was originally developed to handle large databases much faster than the existing solutions and has been successfully used in highly demanding production environments for several years.

A short definition of Relational Database Management System (RDBMS) may be a DBMS in which data is stored in the form of tables and the relationship among the data is also stored in the form of tables.

Although under constant development, MySQL Server today offers a rich and useful set of functions. Its connectivity, speed, and security make MySQL Server highly suited for accessing databases on the Internet.

Now let's go step by step into MySQL from Installation to advanced concepts with syntax and examples.


A Note

MySQL is the most popular open source Relational database Management system (RDBMS). Being a open source anyone can use and change the software for their needs. Hope you enjoy this tutorial. We welcome your Valuable feedbacks or suggestions on this MySQL tutorial. This is a copyright content.


Other Links

web hosting