Difference between revisions of "SQL Syntax Examples"
From Free Knowledge Base- The DUCK Project: information for everyone
m |
m |
||
| Line 1: | Line 1: | ||
A list of SQL statements to serve as examples of syntax. | 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 == | == Examples == | ||
Revision as of 09:41, 1 July 2017
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;
