On 5/8/2014 4:57 AM, Alain Meunier wrote:
Are there any way to insert a row at a specified rowid ?
Just mention rowid in your INSERT statement, the same way you would any other field:
insert into myTable(rowid, otherFields) values(42, 'otherValues');
Is there a way to do it without having an index (storage space) ?
rowid doesn't require a separate index. In a sense, the table itself is its own index - it's stored as a b-tree with rowid as the key.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
