Ok thanks !
> To: [email protected] > From: [email protected] > Date: Thu, 8 May 2014 09:51:56 -0400 > Subject: Re: [sqlite] rowid question > > 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 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
