区域表根据区域id_path 新增一列 name_path

最新推荐文章于 2023-11-07 16:59:02 发布

hanjq_code

最新推荐文章于 2023-11-07 16:59:02 发布

阅读量247

点赞数

分类专栏： mysql 文章标签： sql mysql 数据库

本文链接：https://blog.csdn.net/hanjiaqian/article/details/125598426

版权

mysql 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

在这里插入图片描述

UPDATE sys_area_copy1 aa
LEFT JOIN (
	SELECT
		area.area_id,
		(
		SELECT
			GROUP_CONCAT( spliceArea.area_name ORDER BY spliceArea.LEVEL SEPARATOR '-' ) AS areaPathName 
		FROM
			sys_area spliceArea 
		WHERE
			spliceArea.area_id IN (
			SELECT DISTINCT
				SUBSTRING_INDEX( SUBSTRING_INDEX( excisionArea.area_path, '/', ht.help_topic_id + 1 ), '/',- 1 ) 
			FROM
				sys_area_copy1 excisionArea
				JOIN mysql.help_topic ht ON ht.help_topic_id < ( length( excisionArea.area_path ) - length( REPLACE ( excisionArea.area_path, '/', '' ) ) + 1 ) 
			WHERE
				excisionArea.area_id = area.area_id 
			) 
		) AS areaPathName 
	FROM
		sys_area_copy1 area 
	) bb ON aa.area_id = bb.area_id 
	SET area_path_name = bb.areaPathName