SQL快速参考
来自W3School的SQL快速参考。可以打印它,以备日常使用。
SQL语句
语句 语法 AND/OR SELECTcolumn_name(s)FROMtable_nameWHEREconditionAND|ORcondition ALTERTABLE(addcolumn) ALTERTABLEtable_name?ADDcolumn_namedatatype ALTERTABLE(dropcolumn) ALTERTABLEtable_name?DROPCOLUMNcolumn_name AS(aliasforcolumn) SELECTcolumn_nameAScolumn_aliasFROMtable_name AS(aliasfortable) SELECTcolumn_nameFROMtable_name?AStable_alias BETWEEN SELECTcolumn_name(s)FROMtable_nameWHEREcolumn_nameBETWEENvalue1ANDvalue2 CREATEDATABASE CREATEDATABASEdatabase_name CREATEINDEX CREATEINDEXindex_nameONtable_name(column_name) CREATETABLE CREATETABLEtable_name(column_name1data_type,column_name2data_type,.......) CREATEUNIQUEINDEX CREATEUNIQUEINDEXindex_nameONtable_name(column_name) CREATEVIEW CREATEVIEWview_nameASSELECTcolumn_name(s)FROMtable_nameWHEREcondition DELETEFROM DELETEFROMtable_name?(Note:?Deletestheentiretable!!)
or
DELETEFROMtable_nameWHEREcondition DROPDATABASE DROPDATABASEdatabase_name DROPINDEX DROPINDEXtawww.visa158.com_name DROPTABLE DROPTABLEtable_name GROUPBY SELECTcolumn_name1,SUM(column_name2)FROMtable_nameGROUPBYcolumn_name1 HAVING SELECTcolumn_name1,SUM(column_name2)FROMtable_nameGROUPBYcolumn_name1HAVINGSUM(column_name2)conditionvalue IN SELECTcolumn_name(s)FROMtable_nameWHEREcolumn_nameIN(value1,value2,..) INSERTINTO INSERTINTOtable_nameVALUES(value1,value2,....)
or
INSERTINTOtable_name(column_name1,column_name2,...)VALUES(value1,value2,....) LIKE SELECTcolumn_name(s)FROMtable_nameWHEREcolumn_nameLIKEpattern ORDERBY SELECTcolumn_name(s)FROMtable_nameORDERBYcolumn_name[ASC|DESC] SELECT SELECTcolumn_name(s)FROMtable_name SELECT SELECTFROMtable_name SELECTDISTINCT SELECTDISTINCTcolumn_name(s)FROMtable_name SELECTINTO(usedtocreatebackupcopiesoftables) SELECTINTOnew_table_nameFROMoriginal_table_name
or
SELECTcolumn_name(s)INTOnew_table_nameFROMoriginal_table_name TRUNCATETABLE(deletesonlythedatainsidethetable) TRUNCATETABLEtable_name UPDATE UPDATEtable_nameSETcolumn_name=new_value[,column_name=new_value]WHEREcolumn_name=some_value WHERE SELECTcolumn_name(s)FROMtable_nameWHEREcondition
|
|