DELIMITER $$DROP PROCEDURE IF EXISTS `test`.`p2` $$
CREATE DEFINER=`root`@`%` PROCEDURE `p2`(in tableName varchar(45))
BEGIN
SET @sqlString=CONCAT('
CREATE TRIGGER testref
BEFORE INSERT ON ',tableName,'
FOR EACH ROW
BEGIN
Set new.Name=''aa'';
END'); PREPARE STMT FROM @sqlString;
execute STMT;
DEALLOCATE PREPARE STMT;END $$DELIMITER ;调用时出现如下错误:
This command is not supported in the prepared statement protocol yet
是不是存储过程中不能创建触发器???
CREATE DEFINER=`root`@`%` PROCEDURE `p2`(in tableName varchar(45))
BEGIN
SET @sqlString=CONCAT('
CREATE TRIGGER testref
BEFORE INSERT ON ',tableName,'
FOR EACH ROW
BEGIN
Set new.Name=''aa'';
END'); PREPARE STMT FROM @sqlString;
execute STMT;
DEALLOCATE PREPARE STMT;END $$DELIMITER ;调用时出现如下错误:
This command is not supported in the prepared statement protocol yet
是不是存储过程中不能创建触发器???
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货