dmoaaasqlite語法備忘錄(更新版)
【正文】 TABLE customers。CREATE INDEX為給定表或視圖創(chuàng)建索引。比如執(zhí)行如下一條語句：UPDATE customers SET address = 39。::=updatestatement | insertstatement | deletestatement | selectstatement例子：CREATE TRIGGER update_customer_address UPDATE OF address ON customers ::=DELETE | INSERT | UPDATE | UPDATE OF columnlisttriggeraction::=name [type] [[CONSTRAINT name] columnconstraint]*typeSQLite語法備忘錄作者：coolboy::=CREATE [TEMP | TEMPORARY] TABLE [databasename.] tablename AS selectstatementcolumndef::=CREATE [TEMP | TEMPORARY] TRIGGER triggername INSTEAD OFdatabaseevent ON [databasename .] viewnametriggeractiondatabaseevent ]*ENDtriggerstep說明：創(chuàng)建了一個名為update_customer_address的觸發(fā)器，當用戶更新customers表中的address字段時，將觸發(fā)并更新orders表中的address字段為新的值。Jack Jones39。語法：sqlmandDROP INDEX刪除一個索引。::=columnname = exprDELETE從表中刪除行。::=tablename [AS alias] |( select ) [AS alias]joinop::=BEGIN [TRANSACTION [name]]END TRANSACTION標記一個事務(wù)的終止。::=COPY [ OR conflictalgorithm ] [databasename .] tablename FROM filename[ USING DELIMITERS delim ]例子：COPY::=VACUUM [indexortablename]ATTACH DATABASE附加一個數(shù)據(jù)庫到當前的數(shù)據(jù)庫連接。round(X[,Y])返回數(shù)字表達式并四舍五入為指定的長度或精度。max(X)返回組中值的最大
范文總結(jié)相關(guān)推薦
鄂ICP備17016276號-1