全部產品
Search
文件中心

Lindorm:DELETE

更新時間:Jul 06, 2024

DELETE文法用來刪除表中的行資料,可指定過濾條件。

文法

DELETE FROM table_name WHERE where_clause;

樣本

DELETE FROM dt WHERE p1 = 10 AND p2 = 20;
DELETE FROM dt WHERE p1 > 10;