= Update multiple rows with different values in a single SQL query
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>
Bibliography:
* https://stackoverflow.com/questions/11563869/update-multiple-rows-with-different-values-in-a-single-sql-query
* https://dba.stackexchange.com/questions/69269/updating-multiple-rows-with-different-values-in-one-query
Back to article page