可以用触发器。用语句嘛: 先你可以知道三个互相关联的字段吧。假如是user.yhid=course.yhid 和 course.kcid=article.kcid delete from article where kcid in (select kcid from course where yhid =" & 你已知的那个用户yhid & ") delete from course where yhid =" & 你已知的那个用户yhid delete from user where yhid =" & 你已知的那个用户yhid
先你可以知道三个互相关联的字段吧。假如是user.yhid=course.yhid 和 course.kcid=article.kcid
delete from article where kcid in (select kcid from course where yhid =" & 你已知的那个用户yhid & ")
delete from course where yhid =" & 你已知的那个用户yhid
delete from user where yhid =" & 你已知的那个用户yhid
create trigger