SQL Syntax Examples

A list of SQL statements to serve as examples of syntax.

1. SELECT * FROM customers;
2. SELECT grade, age, reportcategory FROM students WHERE classroom = 3;
3. SELECT username FROM usertable WHERE username like "%icol%";
4. DESCRIBE TABLE customer;
5. SELECT usertable.UserName, Posts.PostID FROM usertable LEFT JOIN Posts ON usertable.UserID = Posts.UserID ORDER BY usertable.UserName;

• Krissy's MySQL Command Reference with Examples
• More MySQL Examples
• Create Table Examples for MySQL
• MySQL database Access and Users
• Data Import Example for MySQL
• Adding MySQL Users