by

Ciro Santilli (@cirosantilli, 32)

UPDATE (SQL)

Table of contents
- Update multiple rows with different values in a single SQL query
- UPDATE with JOIN
  - DELETE with JOIN UPDATE with JOIN

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:

UPDATE with JOIN (SQL)

Dumping examples under nodejs/sequelize/raw/many_to_many.js.

Not possible without subqueries in the standard syntax, a huge shame: stackoverflow.com/questions/1293330/how-can-i-do-an-update-statement-with-join-in-sql-server

The UPDATE + FROM extension exists in a few DBMSs:

Sequelize: UPDATE with JOIN in Sequelize

DELETE with JOIN (SQL)

Demo under: nodejs/sequelize/raw/many_to_many.js.

NO way in the SQL standard apparently, but you'd hope that implementation status would be similar to UPDATE with JOIN, but not even!

PostgreSQL: possible with DELETE FROM USING: stackoverflow.com/questions/11753904/postgresql-delete-with-inner-join
SQLite: not possible without subqueries as of 3.35 far: stackoverflow.com/questions/24511153/how-delete-table-inner-join-with-other-table-in-sqlite, Does not appear to have any relevant features at: www.sqlite.org/lang_delete.html

Sequelize: no support of course: stackoverflow.com/questions/40890131/sequelize-destroy-record-with-join

 Ancestors

Discussion (0)

Sign up or sign in create discussions.

There are no discussions about this article yet.

View article source