Help Center> Distributed Database Middleware> User Guide> SQL Syntax> DML> REPLACE
Updated on 2023-10-09 GMT+08:00
View PDF

REPLACE

REPLACE is used to insert rows into or replace rows in a table.

Common Syntax

replace into table(col1,col2,col3)
values(value1,value2,value3)

Syntax Constraints

  • PARTITION syntax is not supported.
  • If an auto-increment table has no ID, you can insert a data record with a specified ID using REPLACE, but no ID is generated.

Use Constraints

  • If the sharding key value in the REPLACE statement is invalid, data is routed to database shard 0 or table shard 0 by default.
  • Do not use functions VERSION, DATABASE, or USER in the REPLACE statement. When you execute such functions, you may not obtain the expected results because their results depend on whether the statement is pushed to data nodes for execution.
Parent topic: DML