On 16 January 2013 08:16, YAN HONG YE <[email protected]> wrote: > 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|aa8 > > I 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?
Try: create table mytable( ID integer primary key, name nvarchar(32) ); and read up on "integer primary key" and "autoincrement" on the SQLite web-site Regards, Simon _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
