mysql 触发器无法调用存储过程？求解决方案

Question

/**触发器**/
DELIMITER $$

USE road360_new$$

DROP TRIGGER /*!50032 IF EXISTS */ startContract$$

CREATE
/*!50017 DEFINER = 'root'@'localhost' */
TRIGGER startContract BEFORE UPDATE ON road_shop
FOR EACH ROW BEGIN
CALL createTable();
END;
$$

DELIMITER ;

提示：错误代码： 1336
Dynamic SQL is not allowed in stored function or trigger

求支援

Answer 1

不会是你调用存储过程没有加参数吧 = =