方法一、mysql中建立递归查询的方法
-- DROP FUNCTION `getChildrenOrg`
CREATE FUNCTION `getChildrenOrg`(uuid INT) RETURNS text CHARSET utf8
BEGIN
DECLARE sTemp text;
DECLARE sTempChd text;
SET sTemp = '$';
SET sTempChd =cast(uuid as CHAR);
WHILE sTempChd is not null DO
SET sTemp = concat(sTemp
版权声明：本文为wang9820原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。