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 vote362 views1 answer
Dynamic where clause in sql server stored procedure
SQL
0 vote321 views2 answers
Csv into data postgres
SQL
1 vote357 views1 answer
Sql server read uncommitted
SQL
0 vote316 views1 answer
Left join in codeigniter query builder
SQL
0 vote332 views1 answer
Systems sql
SQL
4 votes327 views2 answers
Select first and last row mysql
SQL
1 vote332 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
0 vote319 views1 answer
Import sql dump into postgresql database
SQL
0 vote327 views2 answers
Update all columns in one update
SQL
0 vote269 views1 answer
Import sql file in mysql linux
SQL