sqlite語法備忘錄-在線瀏覽
2024-09-02 06:42本頁面
【正文】 FOR EACH STATEMENT ] [ WHEN expression ] BEGIN triggerstep 。 ]*ENDtriggerstep BEGIN說明：創(chuàng)建了一個(gè)名為update_customer_address的觸發(fā)器，當(dāng)用戶更新customers表中的address字段時(shí)，將觸發(fā)并更新orders表中的address字段為新的值。1 Main St.39。Jack Jones39。1 Main St.39。Jack Jones39。語法：sqlstatement::=name [ COLLATE collationname] [ ASC | DESC ]例子：CREATE INDEX說明：為customers表中的創(chuàng)建一個(gè)名為idx_的字段。語法：sqlmandDROP VIEW刪除一個(gè)視圖。::=DROP VIEW viewname例子：DROP VIEW master_view。語法：sqlstatementDROP INDEX刪除一個(gè)索引。::=DROP INDEX [databasename .] indexname例子：DROP INDEX idx_。語法：sqlstatement語法：sqlstatement::=columnname = exprDELETE從表中刪除行。::=DELETE FROM [databasename .] tablename [WHERE expr]SELECT從表中檢索數(shù)據(jù)。::=SELECT [ALL | DISTINCT] result [FROM tablelist][WHERE expr][GROUP BY exprlist][HAVING expr][poundop select]*[ORDER BY sortexprlist][LIMIT integer [( OFFSET | , ) integer]]result::=* | tablename . * | expr [ [AS] string ]tablelist::=tablename [AS alias] |( select ) [AS alias]joinop::=[ON expr] [USING ( idlist )]sortexprlist::=[ COLLATE collationname ] [ ASC | DESC ]pound_op::=REPLACE INTO [databasename .] tablename [( columnlist )] VALU
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1