mysql5,触发器里可以调用存储过程吗?

来源:百度知道 编辑:UC知道 时间:2024/06/26 02:26:16
如题

不能吧
create trigger del_stu_for_del_tb_pergi
before delete on tb_perdorm
for each row
begin
declare stucodn varchar(15);
set stucodn = old.stu_codename;
call in_out_Per(1,stucodn,'getout');
end $$
Dynamic SQL is not allowed in stored function or trigger
动态SQL是不允许在触发器中
貌似是这样 英语比较搓!!!