假设删除a表中的classid 为1的行则在b表中执行:
delete from b where classid=1;
无外键?CLASSID不是??
重要有映射的值 就可以用A.CLASSID = B.CLASSID 作为条件
先八有关联的信息插入一个临时表T
然后
delete from a where classid in(select id from T)
delete from b where id in(select id from T)
没明白题目的意思,删除后要什么样的结果?
delete * from a,b where a.classld=b.classld