B V, Phanisekhar <[EMAIL PROTECTED]> wrote: > I wanted to know the algorithm used by sqlite to generate the new > rowid. Assume there can be N distinct rowid's possible, now insert N > records, followed by random deletion of some records. Now what rowid > will be assigned to a new row that is added?
http://www.sqlite.org/autoinc.html Note that N=2^63-1. A typical application would have to work for a very long time to create N records. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
