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 vote208 views1 answer
Postgres extract number from string
SQL
2 votes234 views2 answers
How to DROP a table in mysql
SQL
1 vote152 views1 answer
Sql trigger before delete
SQL
6 votes216 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote186 views1 answer
Pl sql round
SQL
0 vote150 views2 answers
Drop check constraint in ms sql
SQL
0 vote168 views1 answer
How to find table lock and row lock in mysql
SQL
0 vote183 views1 answer
How to input data as id in database sql c#
SQL
18 votes150 views3 answers
Mysql current date
SQL
0 vote167 views1 answer
Sql cnvert bit to nvarchar
SQL