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

1 vote216 views1 answer
PL SQL MODIFY COLUMN NME
SQL
0 vote202 views1 answer
Run sql script file and changes db name in this file using c#
SQL
4 votes220 views2 answers
Tables in sql
SQL
1 vote214 views1 answer
Date in where on datetime column clause mysql
SQL
0 vote201 views2 answers
How to know the character set of an oracle databes
SQL
4 votes193 views4 answers
What is primary key
SQL
0 vote218 views1 answer
Sql ignore
SQL
1 vote203 views1 answer
Sql not equal multiple columns
SQL
0 vote220 views1 answer
Command line mysql xampp
SQL
16 votes224 views1 answer
Mssql int max value
SQL