delimiter $$ drop function if exists get_child_list$$ create function get_child_list(in_wgbm varchar(1000)) returns varchar(1000) begin declare wgbms varchar(1000) default ''; declare tempwgbms varchar(1000); set tempwgbms = in_wgbm; while tempwgbms is not null do set wgbms = CONCAT_WS(',',wgbms,tempwgbms); select GROUP_CONCAT(wgbm) into tempwgbms from grid_org_info where FIND_IN_SET(wgbm,tempwgbms)>0; end while; return wgbms; end $$ delimiter ; 老是报错Data too long for column 'wgbms' at row 1
