MySQL

Deleting rows from multiple tables in MySQL:

You can specify multiple tables in a DELETE statement to delete rows from one or more tables depending on the particular condition in the WHERE clause.

The syntax:

DELETE FROM t1, t2 USING t1 INNER JOIN t2 INNER JOIN t3
WHERE t1.id=t2.id AND t2.id=t3.id;

Example:

Let's consider two tables:

firstName id FIRST NAME 1 Peter 2 James 3 Rita 4 Joanna 9 Ron

lastName id LAST NAME 1 Henderson 2 Morrison 3 Potter 4 Mullick 5 Wayne

I can delete the rows with ID-1,2,3 and 4 in table-1(firstName) and table-2(lastName) with the following query:
DELETE FROM firstName, lastName USING firstName INNER JOIN lastName
WHERE firstName.id=lastName.id

Voila!