Update multiple rows with different values in a single SQL query

New to topics? Read the documentation here!
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-01-10 +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