CREATE DEFINER=`root`@`%` FUNCTION `getparents`(`rootId` int) RETURNS varchar(255) CHARSET utf8
BEGIN
DECLARE i varchar(100) ;
DECLARE n varchar(100) default '';
DECLARE x varchar(100) default '';
DECLARE j varchar(1000) default rootId;
WHILE rootId >0 do
SELECT requirement_item_parent_id,requirement_item_seq_num into i,n FROM nmpa_tech_req WHERE requirement_item_id = rootId;
IF i is not null THEN
SET x = concat('.',n, x);
SET rootId = i;
ELSE
SET rootId = i;
END IF;
END WHILE;
SET x = concat('2.1', x);
return x;
END
mysql递归函数,有id和pid,无限层级查询pid拼接章节号
最新推荐文章于 2024-04-30 14:53:22 发布