DELETE all the old rows except the top 20 new?

How about this - delete all rows except the top 20 by pubDate DELETE idx_links WHERE ID NOT IN (SELECT ID FROM idx_links ORDER BY pubDate DESC LIMIT 0,20) Alternately by the date, and avoiding a subquery for the IN clause: DELETE idx_links WHERE pubDate.

How about this - delete all rows except the top 20 by pubDate. DELETE idx_links WHERE ID NOT IN (SELECT ID FROM idx_links ORDER BY pubDate DESC LIMIT 0,20); Alternately by the date, and avoiding a subquery for the IN clause: DELETE idx_links WHERE pubDate.

I tried that (because I was giving your same answer) but I'm having this error: Err 1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'. I have MySql 5.1.39. – Marco Oct 31 at 22:18 Anyway, +1 for you because I think this could be a good solution for latest MySql releases... – Marco Oct 31 at 22:24 Marco, how about finding the 20th pubDate from the top, and deleting all who are older than that (this time by pubDate, rather than ID).

– p. Campbell Oct 31 at 22:27 No, problem is LIMIT clause in subquery... but believe me, I don't know how to solve this; consider that removing LIMIT I got an error (but I already knew this) telling me Err 1093 - You can't specify target table 'idx_links' for update in FROM clause – Marco Oct 31 at 22:30.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.