设置admin为顶,同一行中的pname 介绍了use_name , 请问 admin为起始 如何统计 admin介绍了多少层 ,pname 介绍了use_name 一次就为一层。 MYSQL 查询语句如何写
解决方案 »
- 求助一个用存储过程实现的mysql数据库查找的问题,求大侠解决啊!
- 想取相同名称的记录中最近的一条
- 我在freebsd 8.1环境下用php+mysql开发了一个用户注册系统!中文注册后出现这个错误!
- mysql command line client 怎样输入中文
- ●●●●一个折腾了我很久的纠结问题,数据库关系问题,我这样行吗?
- mysql load data 中文乱码
- 增加数据库密码?
- postgres数据库端 不支持gbk吗?
- mysql在2000下启动不了
- 各位牛人老大,关于postgres的一点菜问题,进来帮帮忙呀分数我一次只能给这么多会再给分的!
- mysql递归查询统计
- My Sql数据库求教大佬
select 'admin' as user_name, null as p_name from dual union all
select 'gs1' as user_name, 'admin' as p_name from dual union all
select 'gs2' as user_name, 'gs1' as p_name from dual union all
select 'gs3' as user_name, 'gs1' as p_name from dual union all
select 'gs4' as user_name, 'gs2' as p_name from dual union all
select 'cqc' as user_name, 'gs4' as p_name from dual union all
select 'bxp' as user_name, 'cqc' as p_name from dual),
tmp1(user_name, p_name, lvl, p_path) as(
select user_name, p_name, 0 as lvl, cast(user_name as char(200)) as p_path from tmp where p_name is null
union all
select t2.user_name, t2.p_name, t1.lvl + 1 as lvl, concat(t1.p_path, '->', t2.user_name) as path
from tmp1 t1 inner join tmp t2 on t1.user_name = t2.p_name)
select * from tmp1;