sql - How to delete a range of records at once on MySQL?

Question

I have rows over 60000 in my table. How can I delete rows from 40000 to 50000 at once?

Answer 1

You can use the between function:

delete from exampleTable where id between 40000 and 50000

or:

delete from exampleTable where id >= 40000 and id <= 50000

pretty simple?