Syllabus

MySQLSELECT

MySQL WHERE

MySQL AND, OR, NOT

MySQL ORDER BY

MySQL INSERT INTO

MySQL NULL Values

MySQL UPDATE

MySQL DELETE

MySQL LIMIT

MySQL MIN and MAX

MySQL COUNT, AVG, SUM

MySQL LIKE

MySQL Wildcards

MySQL IN

MySQL BETWEEN

MySQL Aliases

MySQL INNER JOIN

MySQL LEFT JOIN

MySQL RIGHT JOIN

MySQL CROSS JOIN

MySQL Self Join

MySQL UNION

MySQL GROUP BY

MySQL HAVING

MySQL EXISTS

MySQL ANY, ALL

MySQL CASE

MySQL Null Functions

MySQL Comments

MySQL Create DB

MySQL Drop DB

MySQL Create Table

MySQL Drop Table

MySQL Alter Table

MySQL Constraints

MySQL Not Null

MySQL Unique

MySQL Primary Key

MySQL Foreign Key