SQL Quick Reference

 

SQL Statement	Syntax
AND / OR	SELECT column_name(s)FROM table_nameWHERE conditionAND|OR condition
ALTER TABLE	ALTER TABLE table_nameADD column_name datatype or ALTER TABLE table_name DROP COLUMN column_name
AS (alias)	SELECT column_name AS column_aliasFROM table_nameorSELECT column_nameFROM table_name  AS table_alias
BETWEEN	SELECT column_name(s)FROM table_nameWHERE column_nameBETWEEN value1 AND value2
CREATE DATABASE	CREATE DATABASE database_name
CREATE TABLE	CREATE TABLE table_name(column_name1 data_type,column_name2 data_type,column_name2 data_type,… )

Advertisements