How do I make an UPDATE while joining tables on SQLite?

by

You can’t. SQLite doesn’t support JOINs in UPDATE statements.

But, you can probably do this with a subquery instead:

UPDATE closure SET checked = 0 
WHERE item_id IN (SELECT id FROM item WHERE ancestor_id = 1);

Or something like that; it’s not clear exactly what your schema is.

More Related Contents:

  1. SQL update from one Table to another based on a ID match
  2. MySQL update table based on another tables value
  3. How to do an update + join in PostgreSQL?
  4. INSERT IF NOT EXISTS ELSE UPDATE?
  5. How to delete or add column in SQLITE?
  6. How to use ROW_NUMBER in sqlite
  7. Android – Pulling SQlite database android device
  8. SQLite – How do you join tables from different databases?
  9. ALTER COLUMN in sqlite
  10. Insert new column into table in sqlite?
  11. Efficient paging in SQLite with millions of records
  12. How do you enable LIMIT for DELETE in SQLite?
  13. SQLite Schema Information Metadata
  14. How to create custom functions in SQLite
  15. Sqlite group_concat ordering
  16. is there a limit to the size of a SQLite database?
  17. How to generate all dates between two dates
  18. Does it matter what extension is used for SQLite database files?
  19. How do I DROP a constraint from a sqlite (3.6.21) table?
  20. How do I add a new column in between two columns?
  21. change sqlite file size after “DELETE FROM table”
  22. Are there any reserved words in SQLite?
  23. What is the difference between related SQLite data-types like INT, INTEGER, SMALLINT and TINYINT?
  24. Modify a Column’s Type in sqlite3
  25. Case sensitive and insensitive like in SQLite
  26. SQLite accent-insensitive search
  27. Will SQLite performance degrade if the database size is greater than 2 gigabytes?
  28. SQLite for large data sets?
  29. SQLite database supporting Unicode data
  30. SQLITE3 VACUUM, “database or disk is full”

Leave a Comment