手册说: 通过在FOR EACH ROW之后使用BEGIN ... END复合语句结构,能够定义执行多条语句的触发程序。
在BEGIN ... END复合语句中可以添加多条触发程序的呀,我还以为只能添加一条呢写了多条删除的语句结果只执行了一条我以为错了呢。 DELIMITER $$ create trigger xi_delete after delete ON xinxi for each row BEGIN delete from us_xi where userid=old.userid, delete from ccs_image where userid=old.userid, delete from guestbook where userid=old.userid, delete from friends where userid=old.userid; END$$ DELIMITER;
DELIMITER $$ create trigger xi_delete after delete ON xinxi for each row FOR EACH ROW BEGIN delete from us_xi where userid=old.userid, delete from ccs_image where userid=old.userid, delete from guestbook where userid=old.userid, delete from friends where userid=old.userid; END$$ DELIMITER;
通过在FOR EACH ROW之后使用BEGIN ... END复合语句结构,能够定义执行多条语句的触发程序。
DELIMITER $$
create trigger xi_delete after delete
ON xinxi for each row
BEGIN
delete from us_xi where userid=old.userid,
delete from ccs_image where userid=old.userid,
delete from guestbook where userid=old.userid,
delete from friends where userid=old.userid;
END$$
DELIMITER;
create trigger xi_delete after delete
ON xinxi for each row
FOR EACH ROW
BEGIN
delete from us_xi where userid=old.userid,
delete from ccs_image where userid=old.userid,
delete from guestbook where userid=old.userid,
delete from friends where userid=old.userid;
END$$
DELIMITER;