REPLACE INTO

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.

Note

Unlike INSERT INTO and UPDATE, the queries UPSERT INTO and REPLACE INTO don't need to pre-fetch the data, hence they run faster.

• Setting values for REPLACE INTO using VALUES.

Example

REPLACE INTO my_table (Key1, Key2, Value2) VALUES
(1u, "One", 101),
(2u, "Two", 102);
COMMIT;

• Fetching values for REPLACE INTO using a SELECT.

Example

REPLACE INTO my_table
SELECT Key AS Key1, "Empty" AS Key2, Value AS Value1
FROM my_table1;
COMMIT;