dmoaaasqlite語(yǔ)法備忘錄(編輯修改稿)
2024-08-21 23:52 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 thm ]columnname::=name [ COLLATE collationname] [ ASC | DESC ]例子：CREATE INDEXidx_ ON customers ()。說(shuō)明：為customers表中的創(chuàng)建一個(gè)名為idx_的字段。結(jié)構(gòu)刪除DROP TABLE刪除表定義及該表的所有索引。語(yǔ)法：sqlmand::=DROP TABLE [databasename.] tablename例子：DROP TABLE customers。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 exp
范文總結(jié)相關(guān)推薦
鄂ICP備17016276號(hào)-1