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 vote112 views1 answer
Time in sql server
SQL
0 vote111 views3 answers
Database restoring error
SQL
1 vote154 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
0 vote112 views3 answers
Create and attach user to a postgresql database
SQL
0 vote113 views2 answers
Getting customers with no orders sql
SQL
0 vote116 views4 answers
How to drop all tables in sql
SQL
0 vote105 views1 answer
Why we have to set the password for my sql server
SQL
11 votes117 views2 answers
Turn off safe mode mysql
SQL
7 votes125 views2 answers
Postgres concat
SQL
1 vote188 views1 answer
Postgres set column based on another column
SQL