SQLite Forum

Start rowid from 0
Login
Perhaps:<code>
sqlite> create table LoveMyZero( nzid integer primary key, znum integer generated always as (nzid-1) virtual, payload text);
sqlite> insert into LoveMyZero values (null, "First entry");
sqlite> select * from LoveMyZero;
1|0|First entry
sqlite>
</code>