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

6 votes233 views5 answers
Sql add months to date
SQL
0 vote178 views1 answer
Java spring boot connect to sql server
SQL
0 vote227 views1 answer
Check if record exists mysql
SQL
1 vote247 views1 answer
Dropping a constraint in ms sql
SQL
1 vote225 views2 answers
Mysql remove first and last character from string
SQL
0 vote239 views1 answer
Shortcut run sql pgadmin
SQL
0 vote287 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
0 vote243 views1 answer
Doesn't have default value mysql
SQL
0 vote243 views1 answer
Alter table engine mysql
SQL
5 votes205 views2 answers
Create table
SQL