mysql报错1415Not allowed to return a result set from a trigger 不知如何修改

Question

mysql报错1415Not allowed to return a result set from a trigger 不知如何修改

相关代码如下：

DELIMITER //
CREATE PROCEDURE resource_id(out next_value int)
BEGIN
DECLARE prefix VARCHAR(2);
  DECLARE max_id varchar(10);
 
  -- 获取当前表中最大的主键值
  SELECT MAX(rid) INTO max_id FROM resource;
 
  SET next_value = CAST(SUBSTRING(max_id,6, 3) AS UNSIGNED) + 1;
  -- 根据当前最大的主键值生成下一个递增值
 
  -- 返回生成的递增主键值
  SELECT next_value;
END //
DELIMITER ;

DELIMITER $$
DROP TRIGGER IF EXISTS`tri_res`$$

CREATE TRIGGER tri_res BEFORE INSERT ON RESOURCE FOR EACH ROW
BEGIN
   DECLARE NEXT INT;
   DECLARE n INT;
   DECLARE pid VARCHAR(10);
   
   SELECT LEFT(provinceid,3)  INTO pid
   FROM city,RESOURCE WHERE city.city=resource.ricty LIMIT 1;

   CALL resource_id(NEXT);
   SELECT NEXT INTO n;
   
   IF new.rtype = '餐饮美食'
   THEN
   SET new.rid = CONCAT('CY',pid, LPAD(n, 2, '0'));
   END IF;
 
END $$
DELIMITER ;

Answer 1

ERROR 1415 (0A000): Not allowed to return a result set from a trigger_error 1415: not allowed to return a result set fro-CSDN博客 文章浏览阅读4.8k次，点赞34次，收藏15次。最近阅读《MySQL必知必会》一书时，有关触发器那一章有个实例代码无法正确运行，书中代码为：CREATE TRIGGER newproduct AFTER INSERT ON productsFOR EACH ROW SELECT 'Product added';执行的时候会报ERROR 1415 (0A000): Not allowed to return a result ..._error 1415: not allowed to return a result set from a trigger https://blog.csdn.net/Mr_Programming_Liu/article/details/89376988