Replace Query

Replace query is used to insert or update records to a csv file.

If records matching key_columns exist, the records are updated. Otherwise, insert records.

Insert or Update Values

[WITH common_table_expression [, common_table_expression ...]]
  REPLACE INTO table_name
  [(column [, column ...])]
  USING (key_column [, key_column ...]))
  VALUES row_value [, row_value ...]

common_table_expression: Common Table Expression
table_name: identifier or Table Object
column: field reference
key_column: field reference
row_value: Row Value

Insert or Update From Select Query

[WITH common_table_expression [, common_table_expression ...]]
  REPLACE INTO table_name
  [(column [, column ...])]
  USING (key_column [, key_column ...]))
  select_query

common_table_expression: Common Table Expression
table_name: identifier or Table Object
column: field reference
key_column: field reference
select_query: Select Query