int control = intent.getIntExtra("control", -1);
switch(control) {
case 1:
case 2:
db.execSQL("delete from t_music_one");
Log.d("测试","成功");
break;
case 3:
}这里t_music_one 是表名,这样写的话运行不了,表里面的主键是music_Id,是自动增长的,求大侠们解答下,谢谢
switch(control) {
case 1:
case 2:
db.execSQL("delete from t_music_one");
Log.d("测试","成功");
break;
case 3:
}这里t_music_one 是表名,这样写的话运行不了,表里面的主键是music_Id,是自动增长的,求大侠们解答下,谢谢
如果要自动增长列归零可以
1.先Drop table然后再create table
2.或者delete数据之后执行"update sqlite_sequence set seq=0 where name='t_music_one'";