首页 > 代码库 > 迭代查询
迭代查询
元数据:
迭代查询:
CREATE FUNCTION `vendor_area_child`(rootId INT) RETURNS varchar(1000) BEGIN DECLARE pTemp VARCHAR(1000); DECLARE cTemp VARCHAR(1000); DECLARE nTemp VARCHAR(1000); SET pTemp = ‘$‘; SET cTemp =cast(rootId as CHAR); WHILE cTemp is not null DO SET pTemp = concat(pTemp,‘,‘,cTemp); SELECT group_concat(id) INTO cTemp FROM pd_vendor_area WHERE FIND_IN_SET(parent_id,cTemp)>0; END WHILE; SELECT group_concat(area_name) INTO nTemp FROM pd_vendor_area WHERE FIND_IN_SET(parent_id,pTemp)>0; RETURN nTemp; END;
SELECT a.id, a.area_name, a.chi FROM ( SELECT id, area_name, vendor_area_child (id) AS chi FROM pd_vendor_area WHERE area_type = 1 ) a WHERE a.chi LIKE ‘%广州小区%‘;
迭代查询
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。