In this tutorial, you will learn how to delete existing data from a MySQL database table. Let’s see –
Here is some dummy existing data of the users table, and we will see how we can delete one of those.
SQL query syntax for deleting data
DELETE FROM `table_name` WHERE condition;
The WHERE clause is used to define the condition that determines which record should be deleted.
DELETE FROM `users` WHERE `user_id`=4;
The user whose user_id is 4 has been deleted.