在SQLite上联接表时如何进行UPDATE? [英] How do I make an UPDATE while joining tables on SQLite?

问题描述

我尝试过:

UPDATE closure JOIN item ON ( item_id = id ) 
SET checked = 0 
WHERE ancestor_id = 1

并且:

UPDATE closure, item 
SET checked = 0 
WHERE ancestor_id = 1 AND item_id = id

两者都可与MySQL一起使用，但是它们在SQLite中给了我语法错误.

Both works with MySQL, but those give me a syntax error in SQLite.

如何使此UPDATE/JOIN与SQLite 3.5.9版一起使用?

How can I make this UPDATE / JOIN works with SQLite version 3.5.9 ?

推荐答案

您不能. SQLite 不支持UPDATE语句中的JOIN .

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.

这篇关于在SQLite上联接表时如何进行UPDATE?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！