Update multiple rows with different values in a single SQL query

ID: update-multiple-rows-with-different-values-in-a-single-sql-query

Top articles Latest articles+ New article in topic
Update multiple rows with different values in a single SQL query by Ciro Santilli 35 Updated 2025-03-25 +Created 1970-01-01
This happens when you calculate a bunch of values on your program, and then want to save the to SQL.
Upsert is an option, but it fails if you have a NOT NULL column: Upsert with NOT NULL column
Read the full article

New to topics? Read the docs here!