Upsert in SQL - Hackdot

Re:Upsert in SQL by MarkusWinand on Monday September 25, 2023 @01:56PM (#37647935)

I recently covered MERGE on modern-sql.com: https://modern-sql.com/caniuse/merge

There I also look at limitations of some implementations and problems such as not reporting ambiguous column names — just guessing what you mean ;)

[ Parent | on HN ]

Re:Upsert in SQL by bafe on Monday September 25, 2023 @04:07PM (#37649842)

Great work as always! I still remember looking at your site when I was working on an ETL system for sensor data and realising in frustration how MariaDB was missing all the nice modern SQL functions like merge.

[ Parent | on HN ]