UPSERT in MySQL, PostgreSQL, SQLite & MS SQL Server — A Complete Comparison

One of the most searched SQL topics — and one of the most confusing — is UPSERT: insert a row if it...