SQL-QuickReference
Statement -> Syntax AND / OR -> SELECT column_name(s) FROM table_name WHERE condition ANDOR condition ALTER TABLE(add column) -> ALTER TABLE table_name ADD columnname datatype ALTER TABLE(drop column) -> ALTER TABLE table_name DROP COLUMN column_name AS(alias/colum) -> SELECT column_name AS column_alias FROM table_name AS(alias/table) -> SELECT column_name FROM table_name AS table_alias BETWEEN -> SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2 CREATE INDEX -> CREATE INDEX index_name ON table_name (column_name) CREATE TABLE -> CREATE TABLE table_name ( column_name1 data_type, column_name2 data_type, .......) CREATE UNIQUE INDEX -> CREATE UNIQUE INDEX index_name ON table_name (column_name) CREATE VIEW -> CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition DELETE FROM -> DELETE FROM table_name DELETE FROM table_name WHERE condition(Deletes entire table) DROP DATABASE -> DROP D...
Comments