dmoaaasqlite語法備忘錄-閱讀頁
2025-08-09 23:52本頁面
【正文】 t )] VALUES ( valuelist ) |REPLACE INTO [databasename .] tablename [( columnlist )] selectstatement事務(wù)處理BEGIN TRANSACTION標(biāo)記一個事務(wù)的起始點。::=BEGIN [TRANSACTION [name]]END TRANSACTION標(biāo)記一個事務(wù)的終止。::=END [TRANSACTION [name]]COMMIT TRANSACTION標(biāo)志一個事務(wù)的結(jié)束。::=COMMIT [TRANSACTION [name]]ROLLBACK TRANSACTION將事務(wù)回滾到事務(wù)的起點。::=ROLLBACK [TRANSACTION [name]]其他操作COPY主要用于導(dǎo)入大量的數(shù)據(jù)。::=COPY [ OR conflictalgorithm ] [databasename .] tablename FROM filename[ USING DELIMITERS delim ]例子：COPYEXPLAIN::=EXPLAIN sqlstatementPRAGMA::=PRAGMA name [= value] |PRAGMA function(arg)VACUUM::=VACUUM [indexortablename]ATTACH DATABASE附加一個數(shù)據(jù)庫到當(dāng)前的數(shù)據(jù)庫連接。::=ATTACH [DATABASE] databasefilename AS databasenameDETTACH DATABASE從當(dāng)前的數(shù)據(jù)庫分離一個使用ATTACH DATABASE附加的數(shù)據(jù)庫。::=DETACH [DATABASE] databasenameSQLite內(nèi)建函數(shù)表算術(shù)函數(shù)abs(X)返回給定數(shù)字表達式的絕對值。min(X,Y[,...])返回表達式的最小值。round(X[,Y])返回數(shù)字表達式并四舍五入為指定的長度或精度。lower(X)將大寫字符數(shù)據(jù)轉(zhuǎn)換為小寫字符數(shù)據(jù)后返回字符表達式。substr(X,Y,Z)返回表達式的一部分。glob(A,B)條件判斷函數(shù)coalesce(X,Y[,...])ifnull(X,Y)nullif(X,Y)集合函數(shù)avg(X)返回組中值的平均值。max(X)返回組中值的最大值。sum(X)返回表達式中所有值的和。last_insert_rowid()返回最后插入的數(shù)據(jù)的ID。change_count()返回受上一語句影響的行
范文總結(jié)相關(guān)推薦
鄂ICP備17016276號-1