OurBigBook
About
$
Donate
Sign in
+
Sign up
Ciro Santilli
@cirosantilli
34
Follow (8)
Message
Incoming links:
Upsert with
NOT NULL
column
Show body
Body
0
Update multiple rows with different values in a single SQL query
Updated
2024-12-15
+
Created
1970-01-01
View more
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:
stackoverflow.com/questions/11563869/update-multiple-rows-with-different-values-in-a-single-sql-query
dba.stackexchange.com/questions/69269/updating-multiple-rows-with-different-values-in-one-query
Total
articles
:
1