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 vote111 views1 answer
Sql server list table sizes
SQL
0 vote102 views1 answer
What is the use of index in mysql table
SQL
2 votes90 views1 answer
Oracle sql drop column if exists
SQL
0 vote121 views1 answer
Oracle current date minus 1 day
SQL
0 vote101 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote58 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
0 vote112 views1 answer
Mysql check if lowercase
SQL
22 votes173 views4 answers
Tsql rename table
SQL
6 votes99 views2 answers
How to get yesterday date in mysql
SQL
0 vote94 views1 answer
Mysql sum per week
SQL