请问MySQL多表删除的问题
DELETE class,subject,list FROM class,subject,list where class.ClassID=112 and subject.ClassID=112 and list.ClassID=112
我想删除class、subject和list表里所有ClassID=112的记录,上面的语句执行没提示出错,可为什么表里的记录都不能删除呢?
这样写也是没效果的
DELETE class,subject,list FROM class,subject,list where class.ClassID=112 and subject.ClassID=class.ClassID and list.ClassID=class.ClassID
谢谢指点啊~~ :)