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

17 votes204 views2 answers
Mysql date to string
SQL
0 vote185 views3 answers
Remove folders from remote git
SQL
5 votes211 views1 answer
Get column name sql server
SQL
0 vote185 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
1 vote221 views1 answer
Oracle columns table
SQL
1 vote192 views1 answer
Mysql get max value and id
SQL
0 vote182 views1 answer
Php mysqli install
SQL
0 vote197 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
1 vote212 views3 answers
How to update column name in psql
SQL
1 vote201 views2 answers
Oracle leftmost characters
SQL