MySQL Tutorial – Learn and Master MySQL

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
  • CREATE USER statement
  • DROP USER statement
• TABLE
  • CREATE TABLE statement
  • DROP TABLE statement
  • ALTER TABLE statement
  • RENAME TABLE statement
• 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
  • COUNT()
  • SUM()
  • AVG()
  • MAX()
  • MIN()
• String functions
  • SUBSTRING()
  • CONCAT()
  • SUBSTRING_INDEX()
  • LENGTH()
  • INSTR()
  • LOCATE()
  • LEFT()
  • RIGHT()
  • REPLACE()
• 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 LOOP

MySQL Backup and Restore

• Backup MySQL database

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.