OurBigBook About$ Donate
 Sign in+ Sign up

Ciro Santilli @cirosantilli 37

 Message
User's profile image

 Incoming links: Upsert with NOT NULL column

Update multiple rows with different values in a single SQL query  Updated 2025-05-29  +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
 Read the full article
Total articles: 1
 About$ Donate Content license: CC BY-SA 4.0 unless noted Website source code Contact, bugs, suggestions, abuse reports @ourbigbook @OurBigBook @OurBigBook