| title | keywords | description | |
|---|---|---|---|
DML |
|
Seata 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 Examples | Support |
|---|---|---|
| INSERT | INSERT 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 |
| UPDATE | UPDATE tb1_name SET col_name1=expr1 [, col_name2=expr2 ...][WHERE where_definition] |
Yes |
| DELETE | DELETE FROM tb1_name [WHERE where_definition] |
Yes |
| SELECT | SELECT [ALL | DISTINCT | DISTINCTROW ]select_expr, ... FROM tb1_name[WHERE where_definition] |
Yes |
| REPLACE | REPLACE [LOW_PRIORITY | DELAYED][INTO] tb1_name [(col_name,...)]VALUES ({expr | DEFAULT},...),(...),... or REPLACE [LOW_PRIORITY | DELAYED][INTO] tb1_nameSET col_name={expr | DEFAULT}, ... |
No |
| TRUNCATE | TRUNCATE [TABLE] tb1_name |
No |
| UPDATE JOIN | UPDATE 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 |