how to delete large number of rows in mysql
Use delete statement with where clause.
For Ex, if there is a table emp, from which we have to delete multiple records simultaneously then use the condition with where clause, as we have done in the following query.
DELETE FROM emp where deptname='software';
The above query will then delete all the records of the employees whose deptname is software.
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.