Mysql 은 Join를 한 후 Update, Delete 할 수 있다.

mysql> select * from names;
+------+-------+
| id   | name  |
+------+-------+
|    1 | Lucho |
|    2 | Lily  |
|    3 | Kiro  |
+------+-------+
3 rows in set (0.00 sec)

mysql> select * from prof;
+-----------+------------+
| person_id | prof       |
+-----------+------------+
|         1 | Programmer |
|         2 | QA         |
|         3 | Sys admin  |
+-----------+------------+
3 rows in set (0.00 sec)

mysql> update names inner join prof on (id = person_id) set prof = 'Workless' where name = 'Kiro';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from prof;
+-----------+------------+
| person_id | prof       |
+-----------+------------+
|         1 | Programmer |
|         2 | QA         |
|         3 | Workless   |
+-----------+------------+
3 rows in set (0.00 sec)

mysql> delete from names, prof using names inner join prof on (id = person_id) where name = 'Kiro';
Query OK, 2 rows affected (0.00 sec)

mysql> select * from names;
+------+-------+
| id   | name  |
+------+-------+
|    1 | Lucho |
|    2 | Lily  |
+------+-------+
2 rows in set (0.00 sec)

mysql> select * from prof;
+-----------+------------+
| person_id | prof       |
+-----------+------------+
|         1 | Programmer |
|         2 | QA         |
+-----------+------------+
2 rows in set (0.00 sec)

mysql>