在Android的SQLite的重置自动增量 [英] Resetting Autoincrement in Android SQLite

问题描述

我有这样的方法，将删除所有行从表中，但我也希望它重新设置自动增量，这样，当一个新的行被添加它会重新开始。由于某些列的SQL语句我使用的心不是工作不存在。我做对吗？

 私人无效rmvall（）{

    SQLiteDatabase DB = appts.getWritableDatabase（）;
    db.delete（TABLE_NAME，NULL，NULL）;
    db.execSQL（DELETE FROM SQLITE_SEQUENCE其中name =+ TABLE_NAME）;

}
 

解决方案

你需要在你的表名单引号，即

  db.execSQL（DELETE FROM SQLITE_SEQUENCE其中name ='+ TABLE_NAME +'）;
 

I have this method which will remove all rows from a table but i also want it to reset the autoincrement so that when a new row is added it will start again. The SQL statement i'm using isnt working due to certain columns not existing. Am i doing it right?

private void rmvall() {

    SQLiteDatabase db = appts.getWritableDatabase();
    db.delete(TABLE_NAME, null, null);
    db.execSQL("DELETE FROM SQLITE_SEQUENCE WHERE NAME = " + TABLE_NAME);

}

解决方案

you'll need single quotes around your table name, i.e.

db.execSQL("DELETE FROM SQLITE_SEQUENCE WHERE NAME = '" + TABLE_NAME + "'");

这篇关于在Android的SQLite的重置自动增量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！