dmoaaasqlite語法備忘錄(專業(yè)版)
【正文】 max(X)返回組中值的最大值。::=VACUUM [indexortablename]ATTACH DATABASE附加一個(gè)數(shù)據(jù)庫到當(dāng)前的數(shù)據(jù)庫連接。::=BEGIN [TRANSACTION [name]]END TRANSACTION標(biāo)記一個(gè)事務(wù)的終止。::=columnname = exprDELETE從表中刪除行。語法：sqlmand說明：創(chuàng)建了一個(gè)名為update_customer_address的觸發(fā)器，當(dāng)用戶更新customers表中的address字段時(shí)，將觸發(fā)并更新orders表中的address字段為新的值。::=CREATE [TEMP | TEMPORARY] TRIGGER triggername INSTEAD OFdatabaseevent ON [databasename .] viewnametriggeractiondatabaseevent::=CREATE [TEMP | TEMPORARY] TABLE [databasename.] tablename AS selectstatementcolumndefSQLite語法備忘錄作者：coolboy::=name [type] [[CONSTRAINT name] columnconstraint]*type::=DELETE | INSERT | UPDATE | UPDATE OF columnlisttriggeraction比如執(zhí)行如下一條語句：UPDATE customers SET address = 39。::=DROP TABLE [databasename.] tablename例子：DROP TABLE customers。語法：sqlstatement語法：sqlstatement語法：sqlstatementmin(X)返回組中值的最小值。count(X)返回組中項(xiàng)目的數(shù)量。語法：sqlstatement語法：sqlstatement::=UPDATE [ OR conflictalgorithm ] [databasename .] tablenameSET assignment [, assignment]*[WHERE expr]assignment結(jié)構(gòu)刪除DROP TABLE刪除表定義及該表的所有索引。 END。::=CREATE [TEMP | TEMPORARY] TRIGGER triggername [ BEFORE | AFTER ]databaseevent ON [databas
范文總結(jié)相關(guān)推薦
鄂ICP備17016276號-1