SQL速查.docVIP

AND / OR SELECT column_name(s)FROM table_nameWHERE conditionAND|OR condition ALTER TABLE (add column) ALTER TABLE table_name ADD column_name datatype ALTER TABLE (drop column) ALTER TABLE table_name DROP COLUMN column_name AS (alias for column) SELECT column_name AS column_aliasFROM table_name AS (alias for table) SELECT 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 INDEX CREATE INDEX index_nameON table_name (column_name) CREATE TABLE CREAT