作者官方网站: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