Basic MySQL Tutorial

The basic MySQL tutorial covers everything from managing databases, tables to querying data from tables by using various techniques such as projection, inner join, left join, etc.

Manage Database in MySQL

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.

Understanding MySQL Table Types, or Storage Engines

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

MySQL Data Types

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

Creating Tables Using MySQL CREATE TABLE Statement

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

MySQL Sequence

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

MySQL Primary Key

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

MySQL Foreign Key

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

Changing Table Structure Using MySQL ALTER TABLE

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.

MySQL DROP TABLE - Removing Existing Tables

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

MySQL Temporary Table

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

MySQL Managing Database Index

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.

Using MySQL SELECT Statement to Query Data

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

Filter Rows Using MySQL WHERE

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

MySQL ORDER BY

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.

How to Use MySQL DISTINCT to Eliminate Duplicate Rows

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

Using MySQL LIMIT

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.

Querying Data with MySQL IN Operator

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

MySQL BETWEEN Operator Explained

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

Using MySQL LIKE Operator to Select Data Based On Patterns

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

MySQL Alias

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

Combining Result Sets by Using MySQL UNION

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.

MySQL INNER JOIN

In this tutorial, you will learn how to use MySQL INNER JOIN clause to select data from multiple tables based on join conditions.

MySQL LEFT JOIN

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

MySQL Self Join

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

MySQL GROUP BY

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.

MySQL HAVING

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

MySQL Subquery

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

Inserting Data into Tables Using MySQL INSERT Statement

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

Updating Data Using MySQL UPDATE Statement

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

MySQL UPDATE JOIN

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

Using MySQL DELETE to Remove Data from Tables

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

MySQL ON DELETE CASCADE Deletes Data From Multiple 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.

MySQL DELETE JOIN

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

MySQL TRUNCATE TABLE

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

MySQL TIMESTAMP

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.

MySQL Replace

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

MySQL Transaction

In this tutorial, you will learn what MySQL transactions are and how to use MySQL COMMIT and MySQL ROLLBACK to manage transaction in MySQL.

MySQL Prepared Statement

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.

MySQL Character Set

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

MySQL Collation

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