> If "order by" isn't used in a select statment, does the result records
> ordered in rowid?
If you omit an ORDER BY clause, the order of the resulting data is
undefined. It might happen to be ordered by rowid in some cases, but
this is not guaranteed. (Might change in a future version,
"Wenton Thomas"
wrote in message news:790786.83985...@web111003.mail.gq1.yahoo.com
> If "order by" isn't used in a select statment, does the result
> records ordered in rowid?
Generally, no. It could accidentally happen this way, but there's no
guarantee. If you want a particular order (by
If "order by" isn't used in a select statment, does the result records
ordered in rowid?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
3 matches
Mail list logo