从SQLite for java/安卓中的数据库表中删除除前n之外的所有内容
我是java新手,但我正在尝试编写代码:
SQLiteDatabase db = this.getWritableDatabase();
//db.execSQL("delete from " + TABLE_BOOKMARKS + " where " + KEY_ID + " not in (select " + KEY_ID + " from " + TABLE_BOOKMARKS + " order by " + KEY_ID + " limit 10)" );
//db.execSQL("DELETE FROM " + TABLE_BOOKMARKS + " WHERE " + KEY_ID + " NOT IN (SELECT TOP 10 " + KEY_ID + " FROM " + TABLE_BOOKMARKS + ")" );
db.execSQL("Delete From "+TABLE_BOOKMARKS+" where "+ KEY_ID + " not in (Select Top 10 "+ KEY_ID +" from "+ TABLE_BOOKMARKS + " order by " + KEY_ID +")");
db.close(); // Closing database connection
你可以在代码中看到,我尝试了三种不同的方法,但当我运行它时,我的应用程序返回错误并停止
我犯了这个错误:
安卓.database.sqlite.SQLiteException: near "10": syntax error: , while compiling: Delete From bookmarks where id not in (Select Top 10 id from bookmarks order by id)
# 1 楼答案
你可以试试