If you want to delete a record from any MySQL table, then you can use the SQL command DELETE FROM. You can use this command at the mysql> prompt as well as in any script like PHP.

The following code block has a generic SQL syntax of the DELETE command to delete data from a MySQL table DELETE FROM table_name [WHERE Clause]

The following example will delete a record from the tutorial_tbl whose tutorial_id is 3. root@host# mysql -u root -p password; Enter password:******* mysql> use TUTORIALS; Database changed mysql> DELETE FROM tutorials_tbl WHERE tutorial_id=3; Query OK, 1 row affected (0.23 sec) mysql>