On 8 May 2014, at 9:57am, Alain Meunier <[email protected]> wrote: > Are there any way to insert a row at a specified rowid ? > > Imagine that i wish to insert a row at rowid 9 then 1150; Is it possible ?
Declare a table column as INTEGER PRIMARY KEY. This will make the 'rowid' pseudocolumn merely an alias to this column you have explicitly defined. Then you can specify a value for that column in your INSERT command, change the value in UPDATE commands, etc.. > Is there a way to do it without having an index (storage space) ? You don't have to declare an index, but SQLite has to make one up for the rowid values itself, otherwise they'd be useless. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
