【正文】 ename .] tablenametriggeractionsqlstatement[, constraint]*)sqlmand 來源：亂燉::=typename |typename ( number ) |typename ( number , number )columnconstraint::=[ FOR EACH ROW | FOR EACH STATEMENT ] [ WHEN expression ] BEGIN 1 Main St.39。DROP VIEW刪除一個視圖。::=DELETE FROM [databasename .] tablename [WHERE expr]SELECT從表中檢索數(shù)據(jù)。::=END [TRANSACTION [name]]COMMIT TRANSACTION標(biāo)志一個事務(wù)的結(jié)束。::=ATTACH [DATABASE] databasefilename AS databasenameDETTACH DATABASE從當(dāng)前的數(shù)據(jù)庫分離一個使用ATTACH DATABASE附加的數(shù)據(jù)庫。sum(X)返回表達式中所有值的和。glob(A,B)條件判斷函數(shù)coalesce(X,Y[,...])ifnull(X,Y)nullif(X,Y)集合函數(shù)avg(X)返回組中值的平均值。::=PRAGMA name [= value] |PRAGMA function(arg)VACUUM::=REPLACE INTO [databasename .] tablename [( columnlist )] VALUES ( valuelist ) |REPLACE INTO [databasename .] tablename [( columnlist )] selectstatement事務(wù)處理BEGIN TRANSACTION標(biāo)記一個事務(wù)的起始點。語法：sqlstatement說明：為customers表中的創(chuàng)建一個名為idx_的字段。語法：sqlstatement 時間：2006428::=NOT NULL [ conflictclause ] |PRIMARY KEY [sortorder] [ conflictclause ] |UNIQUE [ conflictclause ] |CHECK ( expr ) [ conflictclause ] |DEFAULT value |COLLATE collationnameconstraint WHERE name = 39