Actually for many rows I delete and insert. Much easier to write. DELETE FROM t WHERE id IN (SELECT id FROM new_data); INSERT INTO t SELECT id, other_field FR

Actually for many rows I delete and insert. Much easier to write. DELETE FROM t WHERE id IN (SELECT id FROM new_data); INSERT INTO t SELECT id, other_field FROM new_data; It seems so natural to me that I do not have to repeat field list. Queries were mostly in context of ETL, so never considered performance issues. Never wrote such code for OLTP.