Hi Richard, On Wed, 2002-03-06 at 13:02, Richard S. Huntrods wrote: > Interestingly enough, pulling records without a sort was rather > random (rather, influence by the last sort) - but once I placed a primary > key on the table, the order of unsorted records is always constant, even > after a sort (based on numerous tests yesterday and today with the tables > and a bunch of selects).
Have you done deletes on the tables too, and later inserts? And done a SELECT that is not based on an index? Anyway, to cut this short: there is no default sort order, so don't rely on it. Otherwise you *will* get bitten at some point. Regards, Arjen. -- MySQL Training in Brisbane: 18-22 March, http://www.mysql.com/training/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php