sqlite語(yǔ)法備忘錄(編輯修改稿)
2025-08-31 09:38 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 ustomers。DROP VIEW刪除一個(gè)視圖。語(yǔ)法：sqlmand::=DROP VIEW viewname例子：DROP VIEW master_view。DROP TRIGGER刪除一個(gè)觸發(fā)器。語(yǔ)法：sqlstatement::=DROP TRIGGER [databasename .] triggername例子：DROP TRIGGER update_customer_address。DROP INDEX刪除一個(gè)索引。語(yǔ)法：sqlmand::=DROP INDEX [databasename .] indexname例子：DROP INDEX idx_。數(shù)據(jù)操作INSERT將新行插入到表。語(yǔ)法：sqlstatement::=INSERT [OR conflictalgorithm] INTO [databasename .] tablename [(columnlist)] VALUES(valuelist) |INSERT [OR conflictalgorithm] INTO [databasename .] tablename [(columnlist)] selectstatementUPDATE更新表中的現(xiàn)有數(shù)據(jù)。語(yǔ)法：sqlstatement::=UPDATE [ OR conflictalgorithm ] [databasename .] tablenameSET assignment [, assignment]*[WHERE expr]assignment::=columnname = exprDELETE從表中刪除行。語(yǔ)法：sqlstatement::=DELETE FROM [databasename .] tablename [WHERE expr]SELECT從表中檢索數(shù)據(jù)。語(yǔ)法：sqlstatement::=SELECT [ALL | DISTINCT] result [FROM tablelist][WHERE expr][GROUP BY exprlist][HAVING expr][poundop select]*[ORDER BY sortexprlist][LIMIT integer [( OFFSET | , ) integer]]result::=resultcolumn [, resultcolumn]*resultcolumn::=* | tablename . * | expr [ [AS] string ]tablelist::=table [joinop table joinargs]*table::=tablename [AS alias] |( select ) [AS alias]joinop::=, |
電大資料相關(guān)推薦
鄂ICP備17016276號(hào)-1