MySQL Forums
Forum List  »  Oracle

Re: Delete all rows in table but keep the last recent 2
Posted by: yvonne kire
Date: September 29, 2009 05:54PM

I am trying to do the delete in a sub query but looks like mysql can not handle it in v5.0

ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Delete all rows in table but keep the last recent 2
5622
September 29, 2009 05:54PM


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.