create table mytable( ID integer primary key autoincrement, name nvarchar(32) );
insert into mytable(name) values("aa1");
insert into mytable(name) values("aa2");
insert into mytable(name) values("aa3");
insert into mytable(name) values("aa4");
insert into mytable(name) values("aa5");
insert into mytable(name) values("aa6");
delete from mytable where id>3;
insert into mytable(name) values("aa7");
insert into mytable(name) values("aa8");
select * from mytable;
1|aa1
2|aa2
3|aa3
7|aa7
8|aa8I wish after I delete any rows from mytable, and then when I insert into any row into mytable, The Id should follow the last exists in mytable. in the sample sql, when I delete any rows in mytable,the last id is 3 , and then when I add any column into mytable, the ID should from 3 to the next column, how to do this? maybe have any rubbish in the database when delete from mytable, how to clean that rubbish? _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
