Basic MySQL Tutorial

You will learn various statements to manage MySQL databases including creating a new database, removing an existing database, selecting a database to work with and listing all databases.

You will learn various MySQL table types, or storage engine. It is essential to understand the features of each table type in MySQL so that you can use them effectively to maximize the performance of your databases

This tutorial shows you various MySQL data types so that you can apply them effectively in designing your database tables.

In this tutorial, we will show you how to create a new tables in a particular database using MySQL CREATE TABLE statement.

This tutorial shows you how to use MySQL sequence to generate unique numbers for ID columns of tables automatically using AUTO_INCREMENT attribute

In this tutorial, you will learn how to use MySQL primary key constraint to create the primary key for the table.

This tutorial introduces you to MySQL foreign key and shows you step by step how to create, add and drop foreign keys in MySQL.

In this tutorial, you will learn about the ALTER TABLE statement that changes existing table structure such as adding or removing column, changing column attribute, etc. We will also show you how to rename the table using ALTER TABLE statement.

In this tutorial, we will show you how to remove existing tables using MySQL DROP TABLE statement.

This tutorial discusses about MySQL temporary table and shows you step by step how to create, use and drop temporary tables.

In this tutorial, you will learn how to work with MySQL index and how to take advantages of MySQL index to speed up the data retrieval.

In this tutorial, we will show you how to use the simple SQL SELECT statement to query the data from database tables in MySQL.

This tutorial show you how to use MySQL WHERE clause to filter rows based on specified conditions.

This tutorial shows you how to sort a result by using MySQL ORDER BY clause. The custom sort order with the FIELD function will be covered.

In this tutorial, you will learn how to use MySQL DISTINCT with SELECT statement to eliminate duplicate rows in a result set.

In this tutorial, you will learn how to use MySQL LIMIT clause to select rows from the beginning, middle and end of a result set.

You will learn how to use MySQL IN operator that determines if a specified value matches any value in a list or a subquery.

In this tutorial, you will learn how to use MySQL BETWEEN operator to specify a range to test.

Shows how to use MySQL LIKE operator to select data based on pattern matching.

This tutorial shows you how to use MySQL alias to improve the readability of the queries.

This tutorial shows you how to use MySQL UNION to combine two or more than two result sets from multiple SELECT statements 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.

Helps you understand MySQL LEFT JOIN concept and how to apply it to query data from two or more database tables.

In this tutorial, you will learn how to use MySQL self join to join a table to itself using join statement.

In this tutorial, you will learn how to use MySQL GROUP BY to group rows into subgroups based on columns or values returned from an expression.

In this tutorial, you will learn how to use MySQL HAVING clause to specify a filter condition for groups of rows or aggregates.

In this tutorial, we will show you how to use MySQL subquery to write more complex queries. In addition, we will show you how to use correlated subquery

In this tutorial, you will learn how to use various forms of MySQL INSERT statement to insert data into database tables.

You will learn how to use UPDATE statement and its options to update data in database tables.

This tutorial shows you how to perform cross table update by using MySQL UPDATE JOIN statement with INNER JOIN and LEFT JOIN.

This tutorial shows you how to use the MySQL DELETE statement to remove data from one or more tables.

Learn how to use MySQL ON DELETE CASCADE referential action for a foreign key to delete data from a child table automatically when you delete data from a parent table.

This tutorial shows you how to delete data from multiple tables by using MySQL DELETE JOIN statement with INNER JOIN and LEFT JOIN.

This tutorial shows you how to use the MySQL TRUNCATE TABLE statement to delete all data in a table.

This tutorial introduces you to MySQL TIMESTAMP and its features called automatic initialization and automatic update that allow you to define auto-initialized and auto-updated columns for a table.

In this tutorial, you will learn how to use MySQL REPLACE statement to insert or update data.

In this tutorial, you will 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 locking for cooperating table access between sessions.MySQL allows a client session to acquire a table lock explicitly for preventing other sessions from accessing the table during a specific period….

We will show you how to use MySQL prepared statement to execute a query with placeholders to improve the speed of the query and make your query more secure.

This tutorial discusses about MySQL character set and shows you step by step how to perform various operations on character sets.

This tutorial discusses about MySQL Collation and shows you how to set character set and collations for the MySQL server, database, tables and columns.