SQL常用腳本大全

SQL常用腳本大全SQL是結(jié)構(gòu)化查詢語言，是一種用于管理數(shù)據(jù)的編程語言，被廣泛應(yīng)用于關(guān)系型數(shù)據(jù)庫的管理和操作中。以下是SQL常用腳本的詳細(xì)介紹：1.創(chuàng)建數(shù)據(jù)庫CREATEDATABASEdatabase_name;2.創(chuàng)建表CREATETABLEtable_name(column1datatype,column2datatype,column3datatype,.....);3.添加列ALTERTABLEtable_nameADDcolumn_namedatatype;4.刪除列ALTERTABLEtable_nameDROPCOLUMNcolumn_name;5.修改列ALTERTABLEtable_nameMODIFYCOLUMNcolumn_namedatatype;6.插入數(shù)據(jù)INSERTINTOtable_name(column1,column2,column3,...)VALUES(value1,value2,value3,...);7.更新數(shù)據(jù)UPDATEtable_nameSETcolumn1=value1,column2=value2,...WHEREcondition;8.刪除數(shù)據(jù)DELETEFROMtable_nameWHEREcondition;9.清空表格TRUNCATETABLEtable_name;10.排序SELECT*FROMtable_nameORDERBYcolumn_nameASC/DESC;11.過濾SELECT*FROMtable_nameWHEREcolumn_nameoperatorvalue;常用的操作符包括：=,<>,>,<,>=,<=,LIKE,IN,NOTIN,BETWEEN,NOTBETWEEN.12.計(jì)數(shù)SELECTCOUNT(*)FROMtable_name;13.求和SELECTSUM(column_name)FROMtable_name;14.平均數(shù)SELECTAVG(column_name)FROMtable_name;15.最大值SELECTMAX(column_name)FROMtable_name;16.最小值SELECTMIN(column_name)FROMtable_name;17.連接表SELECTcolumn_name(s)FROMtable1JOINtable2ONtable1.column_name=table2.column_name;18.左連接SELECTcolumn_name(s)FROMtable1LEFTJOINtable2ONtable1.column_name=table2.column_name;19.右連接SELECTcolumn_name(s)FROMtable1RIGHTJOINtable2ONtable1.column_name=table2.column_name;20.內(nèi)連接SELECTcolumn_name(s)FROMtable1INNERJOINtable2ONtable1.column_name=table2.column_name;21.分組SELECTcolumn_name1,SUM(column_name2)FROMtable_nameGROUPBYcolumn_name1;22.篩選分組SELECTcolumn_name1,SUM(column_name2)FROMtable_nameGROUPBYcolumn_name1HAVINGcondition;23.子查詢SELECTcolumn_name1FROMtable_nameWHEREcolumn_name2(SELECTcolumn_nameFROMtable_nameWHEREcondition);24.表達(dá)式SELECTcolumn_name1,(column_name2*column_name3)ASnew_column_nameFROMtable_name;25.正則表達(dá)式SELECTcolumn_name1FROMtable_nameWHEREcolumn_name2REGE