MySQL Forums
Forum List  »  Oracle

Advanced Search
New Topic

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'

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


Subject
Views
Written By
Posted
Delete all rows in table but keep the last recent 2
15045
yvonne kire
September 23, 2009 01:34PM
Re: Delete all rows in table but keep the last recent 2
5650
Pavel Leonov
September 24, 2009 07:28AM
Re: Delete all rows in table but keep the last recent 2
6101
yvonne kire
September 24, 2009 04:42PM
Re: Delete all rows in table but keep the last recent 2
5664
yvonne kire
September 29, 2009 05:54PM
Re: Delete all rows in table but keep the last recent 2
6107
Garey Guan
September 29, 2009 01:26AM


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.