分布式数据库中间件 DDM-INSERT:常用语法

时间:2024-05-16 15:04:53

常用语法

INSERT [INTO] tbl_name
[(col_name,...)]
{VALUES | VALUE} ({expr },...),(...),...
[ ON DUPLICATE KEY UPDATE
col_name=expr
[, col_name=expr] ... ]
OR
INSERT [INTO] tbl_name
SET col_name={expr | DEFAULT}, ...
[ ON DUPLICATE KEY UPDATE
col_name=expr [, col_name=expr] ... ]
support.huaweicloud.com/usermanual-ddm/ddm-08-0005.html