View Single Post

   
  #4 (permalink)  
Old 02-28-2008, 06:07 AM
Ian P. Christian
 
Posts: n/a
Default Re: a 'safe' way to move data?

Brent Baisley wrote:
> No, you can't assure the same data will be addressed without at least
> including an order by. Even then you would need to make sure that the
> first X records in the order would not change. For instance, if you
> order by entered_date DESC, then the data set would change because any
> new records would get included in the LIMIT.


Will it not always use the natural order of the table in
selects/deletes, and therefore return results in the order in which they
were inserted?


--
Ian P. Christian ~ http://pookey.co.uk
Reply With Quote