android - SQLite 异常 : near "ORDER" while compiling

Question

我试图从数据库表中删除最后插入的项目，但总是出现 SQLiteException: near "ORDER"syntax error (code 1)

android.database.sqlite.SQLiteException: near "ORDER": syntax error (code 1): , while compiling: delete from pending where url = 'server' and mobile_id = '2331' and sent = '0' ORDER BY id DESC LIMIT 1

使用以下查询:

db.execSQL("delete from pending where url = 'server' and mobile_id = '" + string + "' and sent = '0' ORDER BY id DESC LIMIT 1");

Answer 1

使用嵌套查询如下。

db.execSQL("delete from pending where TABLE_ID = (SELECT TABLE_ID from pending where url = 'server' and mobile_id = '" + string + "' and sent = '0' ORDER BY id DESC LIMIT 1"));

TABLE_ID 应该是挂起表的唯一键 ID。