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