sqlite語法備忘錄(存儲版)
【正文】 conflictalgorithm] INTO [databasename .] tablename [(columnlist)] selectstatementUPDATE更新表中的現(xiàn)有數(shù)據(jù)。::=resultcolumn [, resultcolumn]*resultcolumn::=UNION | UNION ALL | INTERSECT | EXCEPTREPLACE類似INSERT語法：sqlstatement語法：sqlstatement::=VACUUM [indexortablename]語法：ATTACH DATABASE附加一個數(shù)據(jù)庫到當前的數(shù)據(jù)庫連接。在附加數(shù)據(jù)庫中添加一個與已有表同名的表是不允許的。若主數(shù)據(jù)庫不是:memory:，多附加數(shù)據(jù)庫的事務是原子的。::=DETACH [DATABASE] databasenameSQLite內建函數(shù)表算術函數(shù)abs(X)返回給定數(shù)字表達式的絕對值。substr(X,Y,Z)返回表達式的一部分。last_insert_rowid()返回最后插入的數(shù)據(jù)的ID。sum(X)返回表達式中所有值的和。lower(X)將大寫字符數(shù)據(jù)轉換為小寫字符數(shù)據(jù)后返回字符表達式。DETTACH DATABASE從當前的數(shù)據(jù)庫分離一個使用ATTACH DATABASE附加的數(shù)據(jù)庫。之后附加的任意與之同名的表需要加前綴。你可以讀寫附加數(shù)據(jù)庫，或改變其結構。::=EXPLAIN sqlstatementPRAGMA語法：sqlstatement語法：sqlstatement::=expr [sortorder] [, expr [sortorder]]*sortorder語法：sqlstatement數(shù)據(jù)操作INSERT將新行插入到表。語法：sqlmand::=CREATE [UNIQUE] INDEX indexname ON [databasename .] tablename ( columnname [, columnname]* )[ ON CONFLICT conflictalgorithm ]columnname WHERE name = 39。view39。::=NOT NULL [ conflictclause ] |PRIMARY KEY [sortorder] [ conflictclause ] |UNIQUE [ conflictclause ] |CHECK ( expr ) [ conflictclause ] |DEFAULT value |COLLATE collationnameconstraintcolumndef [, columndef]*語法：sqlmand語法：sqlmand語法：sql
電大資料相關推薦
鄂ICP備17016276號-1