Hello

L> Lets assume that we have a very simple without any indexing or 
L>constraints. Now we have inserted some data to the table. When we do a 
L>simple "select" query, is it guranteed that the rows will be retrieved 
L>in the same order as they are inserted?

No. It may look like they are being selected in the order they were 
inserted. But there is no guarantee. So you should use an ORDER BY clause 
to get the order you want.

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

Reply via email to