语句
ANDOR
语法SELECTcolum
_
amesFROMtable_
ameWHEREco
ditio
ANDORco
ditio
ALTERTABLEtable_
ame
ALTERTABLEaddcolum

ADDcolum
_
amedatatypeALTERTABLEtable_
ame
ALTERTABLEdropcolum

DROPCOLUMNcolum
_
ameSELECTcolum
_
ameAScolum
_aliasFROMtable_
ameSELECTcolum
_
ameFROMtable_
ameAStable_aliasSELECTcolum
_
amesFROMtable_
ameWHEREcolum
_
ameBETWEENvalue1ANDvalue2
ASaliasforcolum
ASaliasfortable
BETWEEN
CREATEDATABASECREATEINDEX
CREATETABLE
CREATEUNIQUEINDEX
CREATEVIEW
CREATEDATABASEdatabase_
ameCREATEINDEXi
dex_
ameONtable_
amecolum
_
ameCREATETABLEtable_
amecolum
_
ame1data_typecolum
_
ame2data_typeCREATEUNIQUEINDEXi
dex_
ameONtable_
amecolum
_
ameCREATEVIEWview_
ameASSELECTcolum
_
amesFROMtable_
ameWHEREco
ditio
DELETEFROMtable_
ameNoteDeletesthee
tiretableNote
DELETEFROM
or
DELETEFROMtable_
ameWHEREco
ditio
DROPDATABASEdatabase_
ameDROPINDEXtable_
amei
dex_
ameDROPTABLEtable_
ameSELECTcolum
_
ame1SUMcolum
_
ame2FROMtable_
ameGROUPBYcolum
_
ame1SELECTcolum
_
ame1SUMcolum
_
ame2FROMtable_
ameGROUPBYcolum
_
ame1HAVINGSUMcolum
_
ame2co
ditio
value
DROPDATABASEDROPINDEXDROPTABLEGROUPBY
HAVING
fIN
SELECTcolum
_
amesFROMtable_
ameWHEREcolum
_
ameINvalue1value2INSERTINTOtable_
ameVALUESvalue1value2
INSERTINTO
or
INSERTINTOtable_
amecolum
_
ame1colum
_
ame2VALUESvalue1value2SELECTcolum
_
amesFROMtable_
ameWHEREcolum
_
ameLIKEpatter
SELECTcolum
_
amesFROMtable_
ameORDERBYcolum
_
ameASCDESCSELECTcolum
_
amesFROMtable_
ameSELECTFROMtable_
ameSELECTDISTINCTcolum
_
amesFROMtable_
ameSELECTINTO
ew_table_
ameFROMorigi
al_table_
ame
LIKE
ORDERBY
SELECTSELECTSELECTDISTINCTSELECTINTOusedtocreatebackupcopiesoftables
or
SELECTcolum
_
amesINTO
ew_table_
ameFROMorigi
al_table_
ame
TRUNCATETABLEdeleteso
lythedatai
sidethetableUPDATE
TRUNCATETABLEtable_
ameUPDATEtable_
ameSETcolum
_
ame
ew_valuecolum
_
ame
ew_valueWHEREcolum
_
amesome_valueSELECTcolum
_
amesFROMtable_
ameWHEREco
ditio

WHERE
fr