RSS

Monthly Archives: December 2014

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,…

)

Read the rest of this entry »

Advertisements
 

Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

 
%d bloggers like this: