On 19 Oct 2014, at 2:27pm, Baruch Burstein <bmburst...@gmail.com> wrote:

> Is the rowid/'INTEGER PRIMARY KEY' field that is not entered manually
> guaranteed to start from 1? Or at least from a positive number?

See the section 'Background' in

<https://www.sqlite.org/autoinc.html>

for the 'usual' algorithm used for ROWID.  Whatever 'usually' means.  I think 
it means anything that says INTEGER PRIMARY KEY but not INTEGER PRIMARY KEY 
AUTOINCREMENT.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to