Removing records from MyISAM table

Hello,

I wonder if there is a better way to remove records from MyISAM table.
Not just to check all records and delete.
I have table with 80000 records and I want to remove first 50000 records.

 

Hi, try this

DELETE FROM TableName ORDER BY Desired_field ASC LIMIT 50000;

Code (markup):

Regards

 

thank you for quick reply, it works fine