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 vote343 views3 answers
Postgresql grant alter table to user
SQL
0 vote343 views1 answer
Sql stored procedure update if parameter is not null
SQL
0 vote365 views1 answer
How to get one year old query from plan cache
SQL
1 vote333 views1 answer
Import database from a file using mysql commandline
SQL
0 vote342 views1 answer
St_buffer mysql
SQL
0 vote350 views1 answer
Xamarin sql lite create table if not exist
SQL
3 votes329 views1 answer
Mysql replace string in table
SQL
3 votes361 views2 answers
How to open postgresql in windows
SQL
2 votes361 views1 answer
Sql as
SQL
0 vote341 views1 answer
Fill up postgres db
SQL