MySQLExamples
MySQL SELECT
MySQL WHERE
MySQL AND, OR and NOT
MySQL ORDER BY
MySQL NULL Values
MySQL LIMIT
MySQL MIN() and MAX()
MySQL COUNT(), AVG() and SUM()
MySQL LIKE
Select all table rows starting with "a"Select all table rows ending with "a"Select all table rows that have "or" in any positionSelect all table rows that have "r" in the second positionSelect all table rows that starts with "a" and ends with "o"Select all table rows that starts with "a" and are at least 3 characters in lengthSelect all table rows that does NOT start with "a"
MySQL Wildcards
MySQL IN
MySQL BETWEEN
MySQL Aliases
MySQL Joins
MySQL UNION
MySQL GROUP BY
MySQL HAVING
MySQL EXISTS
MySQL ANY and ALL
MySQL CASE
MySQL Comments
Single line CommentSingle line comment at the end of a lineSingle line comments to ignore statementMulti line commentMulti line comment to ignore many statement
MySQL Database
MySQL Database tutorials can be found here:
MySQL Create DBMySQL Drop DBMySQL Create TableMySQL Drop TableMySQL Alter TableMySQL ConstraintsMySQL Not NullMySQL UniqueMySQL Primary KeyMySQL Foreign KeyMySQL CheckMySQL DefaultMySQL Create IndexMySQL Auto IncrementMySQL DatesMySQL Views
