delete recorn in mysql

We have inserted record into the table, and how do we remove a record from a table. In this tutorial, we will learn how to do that with the DELETE statement.

Suppose you want to delete a user from user table with user_id is 6, just execute the following query:

>>DELETE FROM user
WHERE user_id = 6;

To delete all users from user table, just remove the WHERE condition as follows:

>>DELETE FROM user;