Saves data to a table, overwriting the rows based on the primary key. If the given primary key is missing, a new row is added to the table. If the given
PRIMARY_KEY exists, the row is overwritten. The values of columns not involved in the operation are replaced by their default values.
Setting values for
REPLACE INTO my_table (Key1, Key2, Value2) VALUES (1u, "One", 101), (2u, "Two", 102); COMMIT;
Fetching values for
REPLACE INTOusing a
REPLACE INTO my_table SELECT Key AS Key1, "Empty" AS Key2, Value AS Value1 FROM my_table1; COMMIT;