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 vote132 views1 answer
Primary key multiple colums
SQL
29 votes119 views6 answers
Delete all rows from table mysql
SQL
0 vote114 views1 answer
Inser into example
SQL
4 votes164 views1 answer
How to check last gather stats on table in oracle
SQL
1 vote127 views1 answer
Mysql random limit 1
SQL
0 vote142 views1 answer
Postgresql replace html tags from string
SQL
0 vote122 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
2 votes154 views1 answer
Revokeprivileges mysql
SQL
18 votes155 views2 answers
Sql comments
SQL
0 vote127 views1 answer
Oracle exchange subpartition
SQL