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 vote316 views1 answer
Sql remove last x char
SQL
15 votes343 views7 answers
MYSQL
SQL
3 votes358 views2 answers
Sql add year to date
SQL
1 vote345 views1 answer
Mysql select and count left join
SQL
0 vote287 views0 answer
SQL
0 vote338 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
1 vote322 views1 answer
Oracle user last connected
SQL
0 vote558 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote308 views1 answer
Access refused mysql xampp server
SQL
25 votes349 views6 answers
Import mysql database command line
SQL