MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Order table by record insert order
Posted by: Guelphdad Lake
Date: August 31, 2008 08:34AM

Quote

but once I did that it automatically displayed it in the order I originally inserted in.

Then you are making an assumption that could end up giving you trouble down the road. Without an ORDER BY clause there is no guarantee which order the rows will be returned in and it is a bad habit to get in.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Order table by record insert order
Michael Perks
August 30, 2008 09:37AM
Re: Order table by record insert order
Shlomi Noach
August 30, 2008 11:21AM
Re: Order table by record insert order
Michael Perks
August 31, 2008 05:05AM
Re: Order table by record insert order
Guelphdad Lake
August 31, 2008 08:34AM
Re: Order table by record insert order
Shlomi Noach
September 01, 2008 05:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.