The following lines were added (+) and removed (-):
A list of SQL statements to serve as examples of syntax.== Primary Commands ==* SELECT - extracts data from a database* UPDATE - updates data in a database* DELETE - deletes data from a database* INSERT INTO - inserts new data into a database* CREATE DATABASE - creates a new database* ALTER DATABASE - modifies a database* CREATE TABLE - creates a new table* ALTER TABLE - modifies a table* DROP TABLE - deletes a table* CREATE INDEX - creates an index (search key)* DROP INDEX - deletes an index== Examples ==# SELECT * FROM customers;# SELECT grade, age, reportcategory FROM students WHERE classroom = 3;# SELECT username FROM usertable WHERE username like "%icol%";# DESCRIBE TABLE customer;# SELECT usertable.UserName, Posts.PostID FROM usertable LEFT JOIN Posts ON usertable.UserID = Posts.UserID ORDER BY usertable.UserName; # SELECT DISTINCT Name FROM forumusers;* [[Krissy's MySQL Command Reference with Examples]]* <big>[[Krissy's MySQL Command Reference with Examples]]</big>* [[More MySQL Examples]]* <big>[[More MySQL Examples]]</big>