Introduction to MySQL

• MySQL Introduction

• MySQL RDBMS

MySQL SQL Basics

• MySQL SQL

• MySQL SELECT

• MySQL WHERE

• MySQL AND, OR, NOT

• MySQL ORDER BY

• MySQL INSERT INTO

• MySQL NULL Values

• MySQL UPDATE

• MySQL DELETE

• MySQL LIMIT

MySQL Functions & Operators

• MySQL MIN and MAX

• MySQL COUNT, AVG, SUM

• MySQL LIKE

• MySQL Wildcards

• MySQL IN

• MySQL BETWEEN

• MySQL Aliases

• MySQL CASE

• MySQL EXISTS

• MySQL ANY, ALL

• MySQL Null Functions

• MySQL Comments

• MySQL Operators

MySQL Joins & Unions

• MySQL Joins

• MySQL INNER JOIN

• MySQL LEFT JOIN

• MySQL RIGHT JOIN

• MySQL CROSS JOIN

• MySQL Self Join

• MySQL UNION

MySQL Grouping & Filtering

• MySQL GROUP BY

• MySQL HAVING

• MySQL INSERT SELECT

Database & Table Management

• MySQL Create DB

• MySQL Drop DB

• MySQL Create Table

• MySQL Drop Table

• MySQL Alter Table

MySQL Constraints

• MySQL Constraints

• MySQL Not Null

• MySQL Unique

• MySQL Primary Key

• MySQL Foreign Key

• MySQL Check

• MySQL Default

• MySQL Create Index

• MySQL Auto Increment

Date & Views

• MySQL Dates

• MySQL Views

References

• MySQL Data Types

• MySQL Functions