最近要做一个查询 通过递归实现查询到某一个id下面的所有子数据
表结构如下
存储过程代码如下
BEGIN
DECLARE sTemp VARCHAR(4000);
DECLARE sTempChd VARCHAR(4000);
SET sTemp='$';
SET sTempChd = CAST(areaId AS CHAR);
WHILE sTempChd IS NOT NULL DO
SET sTemp= CONCAT(sTemp,',',sTempChd);
SELECT GROUP_CONCAT(CITYID) INTO sTempChd FROM SYSTEM_AREA_CITY WHERE FIND_IN_SET(PARENTID,sTempChd)>0;
END WHILE;
RETURN sTemp;
END
下面是调用存储过程后报错的提示
Procedure execution failed
1406 - Data too long for column 'sTemp' at row 7