BEGIN
DECLARE sTemp text;
DECLARE sTempChd text;
SET@@group_concat_max_len = 102400;
SET sTemp = '$';
SET sTempChd = rootId;
WHILE sTempChd IS NOT NULL DO
SET sTemp = concat(sTemp, ',', sTempChd);
SELECT
group_concat(comcode) INTO sTempChd
FROM
PrpDcompany
WHERE
FIND_IN_SET(UPPERCOMCODE, sTempChd) > 0;
END WHILE;
SET@@group_concat_max_len = 1024;
RETURN SUBSTRING(sTemp,3);
END
这是函数
这是sql
select * from PrpDcompany
where FIND_IN_SET(COMCODE, Dcompany(1044));
这是错误
[SQL]select * from PrpDcompany
where FIND_IN_SET(COMCODE, Dcompany(1044));
[Err] 1406 - Data too long for column 'sTemp' at row 53