INSERT INTO mysql树统计查询层级，与显示树结构整理

作者官方网站:http://www.wxl568.cn

mysql批量insert into select使用

INSERT INTO tm_clock_search_address (

ID,
DEPT_CODE,
NAME,
ADDRESS,
LONGITUDE,
LATITUDE,
EFFECTIVE_RANGE_RADIUS,
nameAddresCode,
      CREATER,
EDITOR
)SELECT A.ID,A.DEPT_CODE,A.NAME ,A.ADDRESS,
A.LONGITUDE,A.LATITUDE,A.EFFECTIVE_RANGE_RADIUS,
concat(A.DEPT_CODE,'_',A.NAME,'_',A.ADDRESS) as nameAddresCode,'hrss','hrss'
FROM tm_clock_address A
WHERE  A.STATUS = 1

    and  not EXISTS (select 1 from tm_clock_search_address b where A.id = B.id  and B.STATUS = 1 )

mysql树统计查询层级，与显示数据结构

SELECT count(ORG_ID)
    FROM ( 
        SELECT 
                @r AS _id, 
                (SELECT @r := ORG_ID_PARENT FROM tm_org WHERE ORG_ID = _id) AS parent_id, 
                 @l := @l + 1 AS lvl 
        FROM 
                (SELECT @r := 82, @l := 0) vars, 
                tm_org h 
        WHERE @r <> 0) T1 
    JOIN tm_org T2 
    ON T1._id = T2.ORG_ID