在MySQL中，刪除關聯的多張表，可以使用下面SQL
mysql> delete e, d from emp e inner join dept d on e.deptno=d.deptno where e.deptno=10;
Query OK, 4 rows affected (0.01 sec)

delete後面的e, d是表的縮寫名

執行成功後，兩張表中的對應資料會被刪除
mysql> select * from dept;
+--------+------------+---------+
| deptno | dname      | loc     |
+--------+------------+---------+
|     20 | RESEARCH   | DALLAS |
|     30 | SALES      | CHICAGO |
|     40 | OPERATIONS | BOSTON |
|     50 | Research   | BeiJing |
+--------+------------+---------+
4 rows in set (0.00 sec)

mysql> select * from emp where deptno=10;
Empty set (0.00 sec)

MySQL 多表關聯刪除

相關文章