1.3.6.4.1. CLICKHOUSE

1.3.6.4.1.1. 删数据 DELETE

描述

支持转换 DELETE 语句

语法

支持的格式如下：

DELETE TABLE table_name [WHERE expr]

警告

• 目前只支持clickhouse

• 具体转换到各库后的差异限制见文档

示例

-- 源SQL:
delete from base_test
delete from base_test where my_tag = 'val6'

-- 目标SQL:
ALTER TABLE base_test DELETE WHERE  1=1
ALTER TABLE base_test DELETE WHERE my_tag='val6'