3 ms·

That's what MySQL's REPLACE does, but not what "upsert" means: http://en.wiktionary.org/wiki/upsert http://en.wiktionary.org/wiki/upsert In presence of foreign

That's what MySQL's REPLACE does, but not what "upsert" means: http://en.wiktionary.org/wiki/upsert http://en.wiktionary.org/wiki/upsert In presence of foreign key constraints for example, DELETE+INSERT might break/fail when UPDATE+INSERT will not. Also, the performance characteristics might be different.

0x0 13y ago
Exactly, the original post (which seems to have been deleted) was claiming otherwise :)
einhverfr 13y ago
If foreign key constraints are deferred, they would be equivalent. It may not be perfect but it's a useful parallel I thought.