SQL Quick Reference

previous

SQL Quick Reference. Print it, and fold it in your pocket.

SQL Syntax

Statement

Syntax
AND / OR

SELECT columnName(s) FROM tableName WHERE condition AND|OR condition;
ALTER TABLE (add column)

ALTER TABLE tableName ADD columnName dataType;
ALTER TABLE (drop column)

ALTER TABLE tableName DROP COLUMN columnName;
AS (alias for column)

SELECT columnName AS columnAlias FROM tableName;
AS (alias for table)

SELECT columnName FROM tableName  AS tableAlias;
BETWEEN

SELECT columnName(s) FROM tableName WHERE columnName BETWEEN value1 AND value2;
CREATE DATABASE

CREATE DATABASE databaseName;
CREATE INDEX

CREATE INDEX indexName ON tableName (columnName);
CREATE TABLE

CREATE TABLE tableName ( columnName1 dataType, columnName2 dataType, ...);
CREATE UNIQUE INDEX

CREATE UNIQUE INDEX indexName ON tableName (columnName);
CREATE VIEW

CREATE VIEW viewName AS SELECT columnName(s) FROM tableName WHERE condition;
DELETE FROM

DELETE FROM tableName  (Note: Deletes the entire table!!);
 or
 DELETE FROM tableName WHERE condition;
DROP DATABASE

DROP DATABASE databaseName
DROP INDEX

DROP INDEX tableName.indexName;
DROP TABLE

DROP TABLE tableName;
GROUP BY

SELECT columnName1,SUM(columnName2) FROM tableName GROUP BY columnName1;
HAVING

SELECT columnName1,SUM(columnName2) FROM tableName GROUP BY columnName1 HAVING SUM(columnName2) condition value;
IN

SELECT columnName(s) FROM tableName WHERE columnName IN (value1,value2, ...);
INSERT INTO

INSERT INTO tableName VALUES (value1, value2, ...);
 or
 INSERT INTO tableName (columnName1, columnName2,...) VALUES (value1, value2, ...);
LIKE

SELECT columnName(s) FROM tableName WHERE columnName LIKE pattern;
ORDER BY

SELECT columnName(s) FROM tableName ORDER BY columnName [ASC|DESC];
SELECT

SELECT columnName(s) FROM tableName;
SELECT *

SELECT * FROM tableName;
SELECT DISTINCT

SELECT DISTINCT columnName(s) FROM tableName;
SELECT INTO (used to create backup copies of tables)

SELECT * INTO newTableName FROM originalTableName;
 or
 SELECT columnName(s) INTO newTableName FROM originalTableName;
TRUNCATE TABLE (deletes only the data inside the table)

TRUNCATE TABLE tableName;
UPDATE UPDATE tableName SET columnName = newValue [, columnName = newValue] WHERE columnName = someValue;
WHERE SELECT columnName(s) FROM tableName WHERE condition;

 

Test your SQL Skills

To test your SQL skills click here.

previous