MySQL Examples
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 position
Select all table rows that have "r" in the second position
Select 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 length
Select all table rows that does NOT start with "a"
MySQL Wildcards
MySQL IN
MySQL BETWEEN
MySQL Aliases
MySQL Joins
INNER JOIN - Join two tables
INNER JOIN - Join three tables
LEFT JOIN
RIGHT JOIN
CROSS JOIN
Self Join
MySQL UNION
MySQL GROUP BY
MySQL HAVING
MySQL EXISTS
MySQL ANY and ALL
MySQL CASE
MySQL Comments
Single line Comment
Single line comment at the end of a line
Single line comments to ignore statement
Multi line comment
Multi line comment to ignore many statement
MySQL Database
MySQL Database tutorials can be found here:
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
MySQL Check
MySQL Default
MySQL Create Index
MySQL Auto Increment
MySQL Dates
MySQL Views