Delete a record using limit with mysql

Databases
1

delete from course_apply order by ca_id desc limit 1000;

i have upload 100000 data in mysql but i can’t able to delete a records only error message through

Bad request or server timeout ,restart

2

why are you sorting the entire table before deleting 1% of the rows?

3

Then only possible delete last 1000 records so only i sort

4

ok…

is there an index on ca_id?

5

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.