SQL Syntax Examples

Examples

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

Other Pages with SQL Examples

• 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