Difference between revisions of "SQL Syntax Examples"

Revision as of 10:39, 1 July 2017

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

Examples

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;

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