MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Order table by record insert order
Posted by: Shlomi Noach
Date: September 01, 2008 05:14AM

I agree.

You must keep to the "ORDER BY FilmID, id" part.
Any changes to the table, like OPTIMIZE TABLE, lots of INSERT+DELETE statements etc. can reorder those lines unexpectedly.

Shlomi

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.