On 15/05/2009 8:41 PM, Pramoda M. A wrote:
> But how to get the rows in the same order of insertion?
> Say, I will insert 2 3 4 and it will store in 2 4 3. But I need in the order 
> 2 3 4. Is it possible?

Possibility (1): Unless you use INTEGER PRIMARY KEY and supply your own 
values for the key column, the ROWID pseudocolumn will be automatically 
given values in ascending sequence. Then you can do queries like:

SELECT * FROM your_table ORDER BY ROWID;

Possibility (2): Have a column named e.g. when_created and populate it 
with CURRENT_TIMESTAMP either implicitly using a DEFAULT column 
constraint in CREATE TABLE, or explicitly when you INSERT. Note: the 
precision of the clock (1 second) may not be enough; you may wish to use 
  ROWID as a tie-breaker in your ORDER BY clause.

... *but* why do you want to recover stuff in insertion order?

HTH,

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

Reply via email to