Changes

SQL Syntax Examples

678 bytes added, 15:44, 1 July 2017
/* Other Pages with SQL Examples */
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# SELECT grade, age, reportcategory FROM students WHERE classroom = 3;# 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>
Bureaucrat, administrator
16,192
edits