MySQL 触发器如何调用存储过程

[joneswood]

delimiter //
create trigger A_trigger after insert on tbl
begin
call A_proc()
end
//
delimiter ;

会出现语法错误，不知道应该怎样改，请高手相助！

[wwwwb]

FOR EACH ROW BEGIN
call A_proc();
end

[joneswood]

可是我是想在load data 之后再触发此触发器，不想用for each row，这个怎麽解决呢？

[ACMAIN_CHM]

很遗憾，你用的mysql而不是oracle

下面是官方文档中的回答。

23.5.3: Does MySQL 5.1 have statement-level or row-level triggers?

In MySQL 5.1, all triggers are FOR EACH ROW — that is, the trigger is activated for each row that is inserted, updated, or deleted. MySQL 5.1 does not support triggers using FOR EACH STATEMENT.


目前MYSQL只支持行级的触发器，不支持语句级的触发器，所以无法解决。

[joneswood]

多谢。我明白了。看来只能想别的办法了。。送分。