The basic MySQL tutorial covers everything from managing databases, tables to querying data from tables by using different techniques such as projection, inner join, left join.
-
In this tutorial you will learn how to manage database in MySQL database server with create and drop database statement.
-
Understanding table types (or storage engine) in MySQL is very important before working with table.
-
To use MySQL effectively, it is very important to understand how MySQL handle data by exploring its data types.
-
MySQL TIMESTAMP is a temporal data type that store combination of date and time values. In this tutorial you will learn how TIMESTAMP values are stored in the database and how to use automatic initialization and automatic update to create created on and last changed on column in a table.
-
In this tutorial you will learn how to create, show and describe tables in MySQL.
-
Learn how to alter and drop table from MySQL database server.
-
Changing existing table structure is a very important task especially when the current table structure no longer reflects the new business's needs. In this tutorial, you will learn about MySQL ALTER TABLE statement to change existing table structure such as add or drop column, change column attribute and rename table.
-
Database indexes help to speed the retrieval of data from MySQL database server faster. Here you learn how to create and drop indexes in table.
-
In this tutorial, we will show you how to use the simple SQL SELECT statement to query the data from database table in MySQL.
-
In this tutorial, you will learn how to MySQL Distinct to eliminate duplicate rows.
-
In this tutorial, you will learn how to constrain number of returned rows by using MySQL Limit keywords along with SELECT statement.
-
You will learn how to retrieve a result set which their values match any one of a list of values by using SQL IN.
-
SQL BETWEEN allows you to retrieve values within a specific range. In this tutorial you will learn work with SQL BETWEEN effectively.
-
MySQL LIKE is commonly used to select data based on patterns matching. Using MySQL LIKE in appropriate way is very important. In this tutorial, you will learn how to use MySQL LIKE when to avoid using it.
-
This tutorial guide you how to use SQL UNION to combine two or more than two result sets from multiple SELECT statement into a single result set.
-
In this tutorial, you will learn how to use MySQL INNER JOIN clause to select data from multiple tables based on join conditions.
-
In this tutorial, you will learn how to use MySQL LEFT JOIN clause to retrieve data from more than one table.
-
In this tutorial, you will learn how to use MySQL GROUP BY to group selected records into a set of summary records by the one or more column's value or expression.
-
In this tutorial, you will learn how to use MySQL HAVING clause to specify a filter condition for a group of records or an aggregate.
-
Shows you how to insert data into table in various ways in MySQL.
-
You will learn how to use UPDATE statement and its options to update data in database tables.
-
This tutorial shows you how to use SQL DELETE statement to delete data from database tables
-
In this tutorial, you will learn how to use MySQL REPLACE statement to insert or update data.
-
In this tutorial, you’ll learn what MySQL transactions are and how to use MySQL COMMIT and MySQL ROLLBACK to manage transaction in MySQL.
-
In this tutorial, you will learn how to use MySQL prepared statement to utilize binary protocol implemented since MySQL 4.1 to make your code more secure and faster.