Hi, I would not rely on the "insertion order" if I were you. Honestly, I don't know how MySQL deals with it but servers such as Microsoft SQL Server or even Access won't provide a deterministic order unless you sort using sort by.
I recomend you to use sort by anyways if you need the result sets sorted, you never know if you want to migrate to another platform. To make things a little bit faster, you can create some sorted indices. Good Luck! --- Steve Edberg <[EMAIL PROTECTED]> wrote: > At 12:00 PM -0500 6/14/02, Jay Blanchard wrote: > >[snip] > >When I say 'select * from table', can I always be > assured of the > >order in which the results are retrieved. If I > issue the query a second > >time, (assuming no new insertions on the table), > will I get the results in > >the same order, again? > >[/snip] > > > >Yes. Data is always sorted from first entered to > last entered unless you > >change the sort with an ORDER BY or GROUP BY. > > > ...unless you do any deletes and subsequent inserts, > or you optimize > the table, or MySQL decides to change internal > record ordering, or... > > As a general rule in relational databases, results > should always be > considered an unordered set unless you EXPLICITLY > specify an ORDER BY. > > - steve > > > >HAGW! > > > >Jay > >sql, mysql, query > > > > > -- > +------------------------------------------------------------------------+ > | Steve Edberg > [EMAIL PROTECTED] | > | University of California, Davis > (530)754-9127 | > | Programming/Database/SysAdmin > http://pgfsun.ucdavis.edu/ | > +------------------------------------------------------------------------+ > | "If only life would imitate toys." > | > | - Ted Raimi, March 2002 > | > | - > http://www.whoosh.org/issue67/friends67a.html#raimi > | > +------------------------------------------------------------------------+ > > --------------------------------------------------------------------- > 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 > __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.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