List:General Discussion« Previous MessageNext Message »
From:Ian P. Christian Date:March 30 2007 2:38pm
Subject:Re: a 'safe' way to move data?
View as plain text  
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
Thread
a 'safe' way to move data?Ian P. Christian30 Mar
  • Re: a 'safe' way to move data?Ananda Kumar30 Mar
  • Re: a 'safe' way to move data?Brent Baisley30 Mar
    • Re: a 'safe' way to move data?Ian P. Christian30 Mar
      • Re: a 'safe' way to move data?Dan Nelson30 Mar
        • Re: a 'safe' way to move data?Ian P. Christian30 Mar