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 vote290 views1 answer
Excel vba import data to sql server
SQL
1 vote310 views1 answer
Mariadb get column names from table
SQL
0 vote251 views1 answer
Full syntax inner join
SQL
0 vote285 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote284 views2 answers
Add new column after in sql
SQL
1 vote260 views1 answer
Mysql count words
SQL
0 vote274 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote257 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote302 views1 answer
Mysql 3 months ago
SQL
1 vote289 views2 answers
Grab part of a string sql
SQL