OurBigBook
About
$
Donate
Sign in
Sign up
Update multiple rows with different values in a single SQL query
Ciro Santilli
(
@cirosantilli,
37
)
...
Type of database
Relational database
Relational database management system
SQL
SQL keyword
UPDATE (SQL)
Updated
2025-07-16
0
Like
0 By others
on same topic
0 Discussions
Create my own 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
(13)
UPDATE (SQL)
SQL keyword
SQL
Relational database management system
Relational database
Type of 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