MySQL Data Manipulation Tutorial
- DELETE statement
- DELETE JOIN
- SELECT statement
- UPDATE statement
- UPDATE JOIN
- INSERT
- INSERT INTO SELECT
- Joins
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- CROSS JOIN
- Operators
- BETWEEN operator
- EXIST operator
- LIKE operator
- AND operator
- OR operator
- IN operator
- ORDER BY clause
- GROUP BY clause
- WHERE clause
- HAVING clause
- LIMIT clause
- UNION clause
- ON DELETE CASCADE
MySQL Data Definition Tutorial
- DATABASE
- CREATE DATABASE statement
- DROP DATABASE statement
- USER
- TABLE
- COLUMN
- ADD COLUMN statement
- DROP COLUMN statement
- RENAME COLUMN statement
- Foreign key
- Primary key
- UNIQUE constraint
MySQL Data Types
- CHAR
- DATE
- DATETIME
- INT
- TIME
- TIMESTAMP
- VARCHAR
MySQL Functions
- Aggregate functions
- String functions
- Dates and times
- DAY()
- MONTH()
- YEAR()
- DATE_ADD()
- DATE_SUB()
- DATE_FORMAT()
- CURDATE()
- GROUP_CONCAT()
- IFNULL() and NULLIF()
- FIND_IN_SET()
- ROW_NUMBER()
MySQL Stored Procedures Tutorial
MySQL Backup and Restore
We are continuing to add tutorials on MySQL to our website. We will update this page as soon as the tutorials are ready. We hope that our tutorials will be a helpful resource for learning and mastering MySQL.