如何在SQLite上連接表時(shí)進(jìn)行更新？我試過：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，但這給我?guī)砹薙QLite中的語法錯(cuò)誤。如何使此更新/連接與SQLite版本3.5.9一起工作？
3 回答
喵喵時(shí)光機(jī)
TA貢獻(xiàn)1846條經(jīng)驗(yàn) 獲得超7個(gè)贊
UPDATE closure SET checked = 0 WHERE item_id IN (SELECT id FROM item WHERE ancestor_id = 1);
慕萊塢森
TA貢獻(xiàn)1810條經(jīng)驗(yàn) 獲得超4個(gè)贊
REPLACE INTO clusure SELECT sel.col1,sel.col2,....,sel.checked --checked should correspond to column that you want to changeFROM ( SELECT *,0 as checked FROM closure LEFT JOIN item ON (item_id = id) WHERE ancestor_id = 1) sel
添加回答
舉報(bào)
0/150
提交
取消