by

Ciro Santilli (@cirosantilli, 34)

UPDATE (SQL)

Table of contents
- Update multiple rows with different values in a single SQL query UPDATE
- UPDATE with JOIN UPDATE
  - 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 (11)

View article source

Discussion (0)

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