Mysql Delete records query

MySQL DELETE Query. If you want to delete a record from any MySQL table,
then you can use DELETE Command.

Syntax:
SQL syntax of DELETE command to delete data from a MySQL table:

DELETE FROM table_name [WHERE Clause]

1.  You can specify any condition using WHERE clause.
   
2.  You can delete records in a single table at a time.

Examples :

delete from country where code=3.

Mysql inner join delete query

Examples

DELETE T1, T2
FROM T1
INNER JOIN T2 ON T1.key = T2.key
WHERE condition