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

3 votes137 views1 answer
Mssql remove column
SQL
15 votes157 views4 answers
Export mysql db using command line
SQL
0 vote199 views1 answer
Show mysql account privilleges
SQL
0 vote148 views1 answer
Procedures sql insert mysql
SQL
0 vote141 views2 answers
Tsql row number
SQL
0 vote138 views1 answer
Create a table from one field of another table
SQL
0 vote144 views1 answer
Windows services sql
SQL
0 vote138 views1 answer
Mysql does collate nopad recognize space
SQL
-1 vote94 views3 answers
Ubuntu install mssql
SQL
1 vote144 views1 answer
Psql human readable
SQL