DELETE#

语法#

DeleteStmt ::=
    DELETE FROM TableName WHERE where_condition

TableName ::=
    Identifier ('.' Identifier)?

说明

  • DELETE 语句删除在线表指定列的索引下面对应值的所有数据

  • WHERE 指定的筛选列必须是索引列并且只能是等于

Examples#

DELETE FROM t1 WHERE col1 = 'aaaa';

DELETE FROM t1 WHERE col1 = 'aaaa' and col2 = 'bbbb';