MySQL DELETE JOIN

MySQL also allows you to use the INNER JOIN clause in the DELETE statement to delete rows from a table and the matching rows in another table.

For example, to delete rows from both T1 and T2 tables that meet a specified condition, you use the following statement:

DELETE T1, T2
FROM T1
INNER JOIN T2 ON T1.key = T2.key
WHERE condition;
Notice that you put table names T1 and T2 between the DELETE and FROM keywords. If you omit T1 table, the DELETE statement only deletes rows in T2 table. Similarly, if you omitT2 table, the DELETE statement will delete only rows in T1 table.

The expression T1.key = T2.key specifies the condition for matching rows between T1 andT2 tables that will be deleted.

The condition in the  WHERE clause determine rows in the T1 and T2 that will be deleted.

Source: mysqltutorial.org

Similar codes

0 vote174 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote189 views1 answer
Sql commands in android
SQL
22 votes170 views6 answers
Create sql table
SQL
2 votes177 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote190 views1 answer
Mysql select statement after index
SQL
0 vote209 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
1 vote204 views3 answers
Sql procedure
SQL
3 votes190 views1 answer
Define REGEXP?
SQL
0 vote200 views2 answers
Homebrew nysql launch
SQL
7 votes198 views2 answers
Where keyword sql
SQL