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

8 votes210 views1 answer
How to remove tables from postgresql
SQL
1 vote223 views1 answer
What is int in mysql
SQL
0 vote221 views1 answer
Running percentage of total postgres
SQL
37 votes226 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
0 vote222 views1 answer
Select the date 30 days less that the todays date sql request
SQL
0 vote227 views1 answer
Get relation data in mysql using query to excel
SQL
0 vote425 views1 answer
Power bi connect to postgresql
SQL
0 vote224 views1 answer
Mysql enter ubuntu
SQL
2 votes198 views3 answers
Mysql cheat sheet
SQL
0 vote214 views1 answer
Mysql table variables
SQL