OurBigBook
.com (beta)
About
$ Donate
Sign in
Sign up
by
Ciro Santilli
(@cirosantilli,
32
)
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:
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
Ancestors
UPDATE
SQL keyword
SQL
Relational database management system
Relational database
Database
Software
Computer
Information technology
Area of technology
Technology
Index
Discussion (0)
Subscribe (1)
Sign up
or
sign in
create discussions.
There are no discussions about this article yet.
View article source