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;