OurBigBook
About
$
Donate
Sign in
+
Sign up
by
Ciro Santilli
(
@cirosantilli,
34
)
Update multiple rows with different values in a single SQL query
...
Database
Relational database
Relational database management system
SQL
SQL keyword
UPDATE (SQL)
Like
(0)
0 By others
on same topic
0 Discussions
Updated
2024-12-15
+
Created
1970-01-01
See my version
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
(12)
UPDATE (SQL)
SQL keyword
SQL
Relational database management system
Relational database
Database
Software
Computer
Information technology
Area of technology
Technology
Home
View article source
Discussion
(0)
Subscribe (1)
+
New discussion
There are no discussions about this article yet.
Articles by others on the same topic
(0)
There are currently no matching articles.
See all articles in the same topic
+
Create my own version