Re: Primary Key Number Sort Issue

[Andrew Gilfrin]

Don't think so, in an rdbms the order the rows are stored in is not important, therefore rows are stored in an unordered fashion, normally assosciated with the first available free space on the disk (unless your using something like Oracles Index Ordered Table). Often it appears as if the rows are ordered but this is just an effect of the disk space being used in a sequencial fashion, as soon as you start to delete rows the order can change significantly.

The only way to make sure things come out in a specific order is to use an explicit order by in the query.

Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information