09 2020 档案

mysql根据某层部门ID查询所有下级多层子部门
摘要：SELECT dept_id, simple_name FROM(SELECT t1.dept_id, t1.simple_name, IF(FIND_IN_SET(pid, @pids) > 0, @pids := CONCAT(@pids, ',', dept_id), 0) AS ischil 阅读全文
posted @ 2020-09-27 16:09 暹罗软件开发 阅读(3708) 评论(2) 推荐(0)