How to delete data inside MySQL table

If you want to delete a record from any MySQL table then you can use the delete command. The delete command is very similar to the update command.

delete from table where where_condition;

The delete statement deletes rows from a table.
The table is the table name.
The where clause specifies the conditions that identify which rows to delete.

The where clause is very useful when you want to delete selected rows in a table. If there is no where clause, all rows will be deleted.
Example:
We want to delete the accounts of user from the database:

+----+----------+--------------------+----+-------+
| id | username | attribute          | op | value |
+----+----------+--------------------+----+-------+
|  1 | user     | Cleartext-Password | := | 123   |
+----+----------+--------------------+----+-------+

This is how we do it.
Just type this command:

delete from radcheck where id=1;

and the accounts of "user" is deleted from the database.