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 vote273 views1 answer
Nested if in mysql
SQL
1 vote282 views1 answer
Psql lst trigger
SQL
6 votes326 views3 answers
Psql show columns of table
SQL
0 vote295 views1 answer
Alter check command
SQL
13 votes319 views3 answers
List all the tables in sql
SQL
6 votes294 views1 answer
Oracle list primary key
SQL
1 vote305 views1 answer
Insert value to new table by joining 2 different tables
SQL
1 vote283 views1 answer
Sql find column name like
SQL
1 vote295 views1 answer
Update mysql centos
SQL
0 vote275 views1 answer
Criteria builder select subset of column
SQL