Shaun R. <[EMAIL PROTECTED]> wrote:
> The rowid looks to reuse numbers when a row is deleted, how can i
> stop this?

create table t(id integer primary key autoincrement, ...);

http://sqlite.org/autoinc.html

Igor Tandetnik



_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to