REPLACE INTO

Warning

Supported only for row-oriented tables. Support for column-oriented tables is currently under development.

Available methods for loading data into columnar tables:

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.

Examples

  • Setting values for REPLACE INTO using VALUES.

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

  • Fetching values for REPLACE INTO using a SELECT.

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