android - SQLite UPDATE 语句获取致命异常

Question

我得到这个异常:

FATAL EXCEPTION: main android.database.sqlite.SQLiteException: near ".": syntax error: , while compiling: UPDATE items SET I.red='1' FROM items I, feeds F  WHERE I.feedLink=F.link AND F.category='Genel'

来自这个声明:

UPDATE items 
SET I.red='1' 
FROM items I, feeds F 
WHERE I.feedLink=F.link AND F.category='Genel'

在 Android 中使用 SQLite。我该如何解决这个问题？

Note: items and feeds are names of my datebase tables.

Answer 1

试试这个

UPDATE items i SET i.red='1' FROM items i, feeds f WHERE i.feedLink=f.link AND f.category='Genel'

如果不行，请尝试将其分成两个查询:

SELECT f.link FROM feeds f WHERE f.category='Genel'

然后在以下查询中使用该结果:

更新项目 i SET i.red='1' WHERE i.feedLink IN([f.link(s) in the result from the prev. query])