多谢版主帅哥 其实我自己写了 但是没好意思拿出来 我是学生 trigger是一个额外加分题 但是我很想挑战一下 所以不用考虑我这个问题的实用性哈 ~~ 多谢 DELIMITER $$ USE `bs39_db`$$ DROP TRIGGER IF EXISTS trd_School_Member; CREATE TRIGGER trd_School_Member AFTER DELETE ON School_Member_Phone FOR EACH ROW BEGIN DELETE School_Member_Phone FROM School_Member_Phoner P, Deleted D WHERE P.ID = D.ID; END DELIMITER
DELETE FROM School_Member_Phoner WHERE ID = old.ID; 建议看一下手册中的例子,显然楼主根本没看。
其实我自己写了 但是没好意思拿出来 我是学生 trigger是一个额外加分题 但是我很想挑战一下 所以不用考虑我这个问题的实用性哈 ~~ 多谢
DELIMITER $$
USE `bs39_db`$$
DROP TRIGGER IF EXISTS trd_School_Member;
CREATE TRIGGER trd_School_Member
AFTER DELETE ON School_Member_Phone
FOR EACH ROW BEGIN
DELETE School_Member_Phone FROM School_Member_Phoner P, Deleted D
WHERE P.ID = D.ID;
END
DELIMITER
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html8、如何给分和结贴?
http://community.csdn.net/Help/HelpCenter.htm#结帖
WHERE P.ID = D.ID; 你写的deleted表或者inserted表是sqlserver的 mysql里直接用old.列名 new.列名 即可