版本:v4.13
DML说明
作为数据目的地,支持的加载方式有insert,update,delete,ignore,merge
| DML类型 | 语法 | 使用限制 |
|---|---|---|
| Insert | copy:copy语法参考plain COPY table_name [ ( column_name [, ...] ) ] FROM STDIN [ [ WITH ] ( option [, ...] ) ] | + 无论目的地是否指定了逻辑主键,皆可以使用。 + 写入数据中如果包含二进制数据,会被转为base64或者hex格式写入,可以通过页面配置。 |
| Update | Update:plain UPDATE <table> [ * ] [ [ AS ] <alias> ] SET { <column> = { <expression> } \| ( <column> [, ...] ) = ( { <expression> } [, ...] ) } [, ...] [ FROM <from_list> ] [ WHERE <condition> ] | 需要指定逻辑主键。 且不支持Update Distribution Key |
| Delete | sql DELETE FROM <table_name> [ * ] [ [ AS ] <alias> ] [ WHERE <condition> ] | 需要指定逻辑主键 |
| Merge | insert on conflct(upsert):sql INSERT INTO <table_name> [ AS <alias> ] [ ( <column_name> [, ...] ) ] { VALUES ( { <expression> } [, ...] ) [, ...] \| <query> } [ ON CONFLICT [ conflict_target ] conflict_action ] where conflict_target is pk ON CONSTRAINT constraint_name and conflict_action is one of: DO NOTHING DO UPDATE SET { <column_name> = { <expression> } \| ( <column_name> [, ...] ) = ( { <expression> } [, ...] ) \| } [, ...] [ WHERE condition ] | 要求必须包含主键 |
| Ingore | 无要求 |