deleting old rows

[Anon]

I know you can use "Limit 20" to only display the 20 top rows in MySQL, but how can I delete everything BUT the first 10 rows?

Thanks

[tomhath]

Read what the manual says about "ORDER BY" and "DESC"

[matto]

delete from tablename where id in(select id from tablename ... blahblah ... limit x,y)

I haven't tried this, but sounds ok ...

[Anon]

Hi!

Subselects don't work in MySQL, it's strictly Access/Oracle/Ms SQL Server feature.

You have to do the select separately, put id values into array using PHP, join this array using implode(",", $array) and feed the resulting string to:

delete from tablename where id not in($string)

Hope it helps,
Stas