Want to delete your data from the table by using the MySQL delete query? If your answer is yes, then this tutorial is specially designed for you. Before deleting data from a table, please make sure you have a proper backup of your data or that data is not important for you.
Below is the syntax of mysql delete query.
1 2 3 |
DELETE FROM table_name WHERE (Specified your condition here); |
Use the above syntax to write a mysql query to delete the data from your mysql database table. Below is an example of delete mysql query:
1 2 |
DELETE FROM employee WHERE emp_id = 6; |
Use the below mysql queries to delete the multiple rows from database table:
1 2 3 4 5 |
#Example 1) Using IN DELETE FROM employee WHERE emp_id IN (1,2,3,4,5); #Example 2 Using BETWEEN DELETE FROM employee WHERE emp_id BETWEEN 1 AND 5; |