mysql存储过程动态创建触发器
mysql存储过程中如何给很多表动态创建触发器?我测试了下:
CREATE DEFINER=`root`@`localhost` PROCEDURE `creattrigger`()
BEGIN
set @sql="CREATE TRIGGER updateValueDay AFTER UPDATE ON value20001 FOR EACH ROW
BEGIN
insert into valueday(time1) values('2111-1-1');
END;";
prepare stmt1 from @sql;
EXECUTE stmt1;
END
报错:1259:——this command is not supported in the prepared statement protocol yet