MySQL Tutorial

MySQL Delete Query

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.

DELETE FROM table_name
WHERE
(Specified your condition here);

DELETE FROM table_name

WHERE

(Specified your condition here);

Delete Query in MySQL

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:

DELETE FROM employee WHERE
emp_id = 6;

1 2	DELETE FROM employee WHERE emp_id = 6;

MySQL Delete Multiple Rows

Use the below mysql queries to delete the multiple rows from database table:

#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;

#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;