delete afrom 表A a, 表B bwhere a.word=b.word;或 delete afrom 表A a inner join 表B b on a.word=b.word;
mysql> select * from A; +------+ | name |a +------+ | A | | B | | C | | D | +------+ 4 rows in set (0.02 sec)mysql> select * from B; +------+ | name | +------+ | B | | C | | E | +------+ 3 rows in set (0.00 sec)mysql> delete from A where name in(select name fro Query OK, 2 rows affected (0.03 sec)mysql> select * from A; +------+ | name | +------+ | A | | D | +------+ 2 rows in set (0.00 sec)
delete afrom 表A a inner join 表B b on a.word=b.word;
+------+
| name |a
+------+
| A |
| B |
| C |
| D |
+------+
4 rows in set (0.02 sec)mysql> select * from B;
+------+
| name |
+------+
| B |
| C |
| E |
+------+
3 rows in set (0.00 sec)mysql> delete from A where name in(select name fro
Query OK, 2 rows affected (0.03 sec)mysql> select * from A;
+------+
| name |
+------+
| A |
| D |
+------+
2 rows in set (0.00 sec)