mysql--删除多表数据

在深入学习mysql之后才发现，原来删除多表数据不需要那么复杂，比如A表，B表关联，当要删除A表中与B表字段值(假设外键为name)相同的记录时

delete A where name in (select name from A,B where A.name = B.name)

如此一来非常麻烦，更优的解法有

delete A from A,B where A.name = B.name

当要删除A表中与B表不匹配的记录并删除时

delete A FROM A LEFT JOIN B on A.SNO = B.SNOwhere B.SNO is NULL;

重头戏来了，当要删除A表和B表的数据相同的数据，实现级联删除怎么做呢delete A,B FROM A LEFT JOIN B on A.name = B.name where A.name = '..';