Skip to main content
Version: v1.0

DML

This article introduces the types of DML statements, SQL instances, and whether Seata supports them, helping you to use SQL more smoothly in Seata.

Type                                   SQL ExamplesSupport                                                     
INSERTINSERT INTO tb1_name (col_name,...) VALUES ({expr | FAULT},...),(...),... or INSERT INTO tb1_name SET col_name={expr | DEFAULT}, ... or INSERT INTO tb1_name (col_name,...) VALUES ({expr | FAULT},...) ON DUPLICATE KEY UPDATE field1=value1,...;Yes
UPDATEUPDATE tb1_name SET col_name1=expr1 [, col_name2=expr2 ...][WHERE where_definition]Yes
DELETEDELETE FROM tb1_name [WHERE where_definition]Yes
SELECTSELECT [ALL | DISTINCT | DISTINCTROW ]select_expr, ... FROM tb1_name[WHERE where_definition]Yes
REPLACEREPLACE [LOW_PRIORITY | DELAYED][INTO] tb1_name [(col_name,...)]VALUES ({expr | DEFAULT},...),(...),... or REPLACE [LOW_PRIORITY | DELAYED][INTO] tb1_nameSET col_name={expr | DEFAULT}, ...No
TRUNCATETRUNCATE [TABLE] tb1_nameNo
UPDATE JOINUPDATE tb1_name tb1 JOIN tb2_name tb2 ON tb2.col_name=tb1.col_name SET tb1.col_name1=expr1 [, tb1.col_name2=expr2 ...][ [WHERE where_definition]Yes,since 1.6.0