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 vote190 views1 answer
T-sql update table variale
SQL
1 vote193 views1 answer
Convert rows to string sql server
SQL
0 vote221 views1 answer
Sql query use select name inside where clause
SQL
0 vote200 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
4 votes214 views1 answer
Mysql ip address data type
SQL
11 votes195 views1 answer
Mysql text type max length
SQL
-1 vote188 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
0 vote192 views1 answer
Python sql last insertend
SQL
-1 vote192 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
11 votes191 views2 answers
Mysql set safe mode off
SQL