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

7 votes369 views3 answers
Foreign key oracle
SQL
24 votes354 views4 answers
Delete db postgres
SQL
1 vote333 views1 answer
Create sample data postgresql
SQL
2 votes352 views1 answer
Mysql virtual column
SQL
0 vote398 views1 answer
Sql statement show all emails with dome
SQL
0 vote308 views1 answer
Java spring boot connect to sql server
SQL
-1 vote320 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
3 votes447 views1 answer
Oracle cannot access v$session
SQL
1 vote344 views1 answer
Ubuntu access database from terminal
SQL
0 vote374 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL