Source: cirosantilli/update-multiple-rows-with-different-values-in-a-single-sql-query

= 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