树形结构机构信息表常用查询_层次查询学习2

最新推荐文章于 2022-01-18 01:02:16 发布
最新推荐文章于 2022-01-18 01:02:16 发布
阅读量4.3k 收藏 1
点赞数
分类专栏： Oracle Develop 文章标签： insert join comments path list null
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/nisjlvhudy/article/details/7586850
版权

本文以一个树型结构层次查询的实例，加深理解。

一、构建表及测试数据

--建表及插入测试数据
-- Create table
create table SYS_JGXXB
(
  JGID  NUMBER not null,
  JGMC  VARCHAR2(50) not null,
  FJGID NUMBER
);
-- Add comments to the columns 
comment on column SYS_JGXXB.JGID
  is '机构ID';
comment on column SYS_JGXXB.JGMC
  is '机构名称';
comment on column SYS_JGXXB.FJGID
  is '上级机构ID';
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7798, '冉庙乡', 7797);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7799, '张湾村', 7798);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7800, '兰堂村', 7798);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7801, '梧樟村', 7798);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7802, '冉庙村', 7798);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7803, '赵集村', 7798);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7804, '新杨堂村', 7798);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7805, '张桥村', 7798);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7806, '乡直', 7798);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7807, '杨楼乡', 7797);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7808, '杨楼村', 7807);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7809, '八里村', 7807);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7810, '王小庄村', 7807);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7811, '前进村', 7807);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7812, '王台村', 7807);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7813, '汤圩村', 7807);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7814, '王屯民族村', 7807);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7815, '张岗村', 7807);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7816, '镇直', 7807);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7817, '乌江乡', 7797);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7818, '乌江', 7817);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7819, '李庄', 7817);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7820, '周圩', 7817);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7821, '李桥', 7817);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7822, '刘大郢', 7817);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7823, '李土楼', 7817);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7824, '龙凤', 7817);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7825, '瓦房', 7817);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7826, '关寺', 7817);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7827, '镇直', 7817);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7828, '正午乡', 7797);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7829, '横山村', 7828);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7830, '吴寨村', 7828);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7831, '王桥村', 7828);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7832, '正午居', 7828);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7833, '田楼居', 7828);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7834, '程圩村', 7828);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7835, '张庙村', 7828);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7836, '大任村', 7828);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7837, '陈庄村', 7828);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7838, '镇直', 7828);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7839, '插花镇', 7797);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7840, '毛桥村', 7839);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7841, '板桥村', 7839);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7842, '赵店村', 7839);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7843, '朱楼村', 7839);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7844, '东黄村', 7839);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7845, '闸南村', 7839);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7846, '兰楼村', 7839);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7847, '郭营村', 7839);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7848, '杨桥村', 7839);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7849, '前于村', 7839);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7850, '曾桥村', 7839);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7851, '中心居', 7839);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7852, '人民居', 7839);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7853, '新元居', 7839);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7854, '成功居', 7839);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7855, '镇直', 7839);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7856, '枣庄镇', 7797);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7857, '蒋楼', 7856);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7858, '李庄', 7856);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7859, '刘庄', 7856);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7860, '宁桥', 7856);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7861, '枣庄', 7856);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7862, '牛庙', 7856);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7863, '童庄', 7856);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7864, '大桥', 7856);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7865, '杨寨', 7856);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7866, '镇直', 7856);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7867, '老庙镇', 7797);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7868, '庙南居委会', 7867);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7869, '庙北居委会', 7867);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7870, '马楼村', 7867);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7871, '马圩村', 7867);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7872, '赵庄村', 7867);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7873, '王海村', 7867);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7874, '李土桥村', 7867);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7875, '公平村', 7867);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7876, '向阳村', 7867);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7877, '镇直', 7867);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7878, '口孜镇', 7797);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7879, '枣元村', 7878);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7880, '王庄村', 7878);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7881, '武后楼村', 7878);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7882, '白元村', 7878);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7883, '饶海村', 7878);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7884, '花园村', 7878);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7885, '王老庄村', 7878);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7886, '曹庄村', 7878);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7887, '济河村', 7878);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7888, '大坝村', 7878);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7889, '钓台村', 7878);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7890, '白屯民族村', 7878);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7891, '焦庄村', 7878);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7892, '洪沟村', 7878);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7893, '洪阳村', 7878);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7894, '杜康村', 7878);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7895, '刘伶居', 7878);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7896, '镇直', 7878);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7897, '袁寨镇', 7797);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7898, '江店', 7897);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7899, '临颖', 7897);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7900, '西康', 7897);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7901, '前楼', 7897);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7902, '郝桥', 7897);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7903, '同庄', 7897);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7904, '河北', 7897);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7905, '北照', 7897);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7906, '袁寨居委会', 7897);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7907, '王海居委会', 7897);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7908, '范沟', 7897);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7909, '武营', 7897);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7910, '镇直', 7897);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7911, '新华办', 7797);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7912, '辛桥', 7911);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7913, '梨树', 7911);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7914, '李洼', 7911);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7915, '蔡湖', 7911);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7916, '吕寨', 7911);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7917, '老集', 7911);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7918, '杨付', 7911);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7919, '任海', 7911);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7920, '处直', 7911);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7921, '河东办', 7797);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7922, '向阳社区', 7921);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7923, '北京路社区', 7921);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7924, '大桥社区', 7921);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7925, '闸东社区', 7921);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7926, '张北社区', 7921);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7927, '枣元社区', 7921);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7928, '訾郢社区', 7921);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7929, '闫前社区', 7921);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7930, '赵大社区', 7921);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7931, '处直', 7921);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7932, '向阳办', 7797);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7933, '东平社区', 7932);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7934, '胡桥社区', 7932);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7935, '桃元社区', 7932);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7936, '致富路社区', 7932);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7937, '幸福东路', 7932);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7938, '关庄社区', 7932);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7939, '振兴路社区', 7932);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7940, '乡直', 7932);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7941, '三角州', 7932);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7942, '二处社区', 7932);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7943, '烟厂社区', 7932);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7944, '同立社区', 7932);
insert into SYS_JGXXB (JGID, JGMC, FJGID)values (7945, '区直', 7797);
COMMIT;


二、查询实例

--1、取树枝
SELECT JGID, JGMC, FJGID
  FROM SYS_JGXXB
 --WHERE CONNECT_BY_ISLEAF = 1
 START WITH FJGID = 7817
CONNECT BY PRIOR JGID = FJGID
 ORDER BY JGID;
 --2、行转列（WMSYS.WM_CONCAT）
SELECT B.JGMC, A.FJGID, WMSYS.WM_CONCAT(A.JGMC)
  FROM SYS_JGXXB A
  LEFT JOIN SYS_JGXXB B
    ON A.FJGID = B.JGID
 GROUP BY B.JGMC, A.FJGID;
--3、行转列（层次函数）
WITH SYS_JGXXB_RANK AS
 (SELECT JGID,
         JGMC,
         FJGID,
         ROW_NUMBER() OVER(PARTITION BY FJGID ORDER BY FJGID) PAR_ROW_NUM
    FROM SYS_JGXXB)
SELECT FJGID, LTRIM(MAX(SYS_CONNECT_BY_PATH(JGMC, ',')), ',') JG_SUB_LIST
  FROM SYS_JGXXB_RANK
 WHERE CONNECT_BY_ISLEAF = 1
 START WITH PAR_ROW_NUM = 1
CONNECT BY PRIOR PAR_ROW_NUM = PAR_ROW_NUM - 1 AND PRIOR FJGID = FJGID
 GROUP BY FJGID, JGID
 ORDER BY FJGID;
--4、行转列（有关联）
WITH SYS_JGXXB_RANK AS
 (SELECT JGID,
         JGMC,
         FJGID,
         ROW_NUMBER() OVER(PARTITION BY FJGID ORDER BY FJGID) PAR_ROW_NUM
    FROM SYS_JGXXB)
SELECT A.FJGID, B.JGMC, LTRIM(MAX(SYS_CONNECT_BY_PATH(A.JGMC, ',')), ',') JG_SUB_LIST
  FROM SYS_JGXXB_RANK A
 INNER JOIN SYS_JGXXB B
    ON A.FJGID = B.JGID
 WHERE CONNECT_BY_ISLEAF = 1
 START WITH A.PAR_ROW_NUM = 1
CONNECT BY PRIOR PAR_ROW_NUM = PAR_ROW_NUM - 1 AND PRIOR A.FJGID = A.FJGID
 GROUP BY A.FJGID, B.JGMC
 ORDER BY A.FJGID;


 

nisjlvhudy
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
java 递归查询组织机构树
上班搞IT，下班搞ITF。
03-21 1万+
java 递归查询组织机构树
java：组织机构树实现名称模糊查询
weixin_41377877的博客
03-02 2124
在开发的很多场景中，需要我们对树形结构进行模糊查询，这个时候就需要用到递归来实现定位，效果如下图： 话不多说，直接上代码吧： 首先是对json的实例化对象处理 public List<PositionGroupModel> jsonToPositionGroupModel(JSONArray objArray){ List<PositionGroupModel> list = new ArrayList<>(); if (Col
组织机构树查询
wzy_king的博客
05-27 1717
组织机构树递归查询 查询父级节点的所有子节点 select organizational_Id,organizational_Name,parent_Id from sys_organizational where is_used = '1' start with parent_id='父级节点id' connect by prior organizational_id=parent_Id （不包含父级节点） select organizational_Id,organizational_Name
Java 递归查询组织机构树
zhuzicc的博客
11-15 3377
需求：现有一个A集合（机构id集合），需要利用A集合查询出集合中所有机构的子级机构，层级（不知道一共有多少级），最终返回所有的子级机构（就是返回一个childOrganList，不包括A集合） 文章目录代码实现聊聊递归递归示例1.计算1~n的和2.递归打印多级目录 代码实现 /** * 根据父级id集合查询所有子孙级id集合 * @param organIdList 父级机构id集合 * @param childOrg 子级机构id集合 * @return.
mysql查询组织机构树路径
一个喜欢诗和远方的程序媛
01-18 2486
Mysql如何获取从根节点开始的完整路径？
Oracle递归树形结构查询功能
09-09
递归树形结构查询主要依赖于`CONNECT BY`和`PRIOR`关键字，它们允许我们构建复杂的层级查询，以展示数据的层次关系。 在Oracle中，树形结构查询的基本语法如下： ```sql SELECT [LEVEL], * FROM table_name START ...
sqlserver 树形结构查询单表实例代码
09-09
本文将详细解析如何通过SQL查询来实现树形结构的单表查询，以供需要的朋友参考。 首先，我们要理解树形结构在数据库中的表现方式。通常，树形结构的数据会在一张表中通过自引用的方式表示，即每个节点都有一个字段...
PostgreSQL树形结构的递归查询示例
09-09
在数据库管理中，处理树形结构的数据是一种常见的需求，例如组织结构、目录树或产品分类等。PostgreSQL 提供了一种方法来处理这种层级关系，即递归查询。本文将详细探讨如何在 PostgreSQL 中进行树形结构的递归查询...
mysql 树形结构查询
04-29
mysql 树形结构查询 MySQL 树形结构查询是指使用存储过程来实现 MySQL 数据库中的树形结构查询。这种查询方式可以高效地查询树形结构的数据，并且可以根据需要设置递归深度。 MySQL 中的树形结构查询可以使用存储...
SqlServer树形结构、层次查询
11-22
SqlServer树形结构、层次查询 结果如下： 1 1 2 1-2 4 1-2-4 5 1-2-5 10 1-2-5-10 8 1-2-5-8 6 1-2-6 3 1-3 7 1-3-7 11 1-3-7-11 9 1-3-7-9 12 1-3-7-9-12 13 1-3-7-9-13 14 1-3-7-9-14
部门树形递归查询
xinpz的博客
07-23 1635
/** * 查询部门列表树 * * @return */ @ResponseBody @RequestMapping("/findOrgTree") public SystemResult findOrgTree(long companyId) { log.info("查询部门列表树入参打印companyId...
oracle查询机构树
zhang8907xiaoyue的博客
10-31 1040
SELECT         jgid,jgmc,jgxz,        LEVEL LVL,        connect_by_isleaf       from tj_base_jg t  start with jgid =1 connect by parentid = prior jgid;
SQL递归查询实现组织机构树
weixin_30808575的博客
05-26 1021
系统用到的组织机构树，要实现对当前节点以及其子节点的查询，数据库SQL要用到递归查询，这也是我第一次接触SQL的递归查询。 先说一下什么是递归查询，简单说来是将一个树状结构存储在一张表里，比如一个表中存在两个字段:code，parent_code，那么通过表示每一条记录的parent是谁，就可以形成一个树状结构，用上述语法的查询可以取得这棵树...
查找树的指定层级_【DB笔试面试478】树形查询（层次查询）可用于哪些场景？...
weixin_42513170的博客
12-31 284
♣答案部分在实际开发中，如果表中数据具有逻辑上的层次结构，那么可以使用层次查询以更直观地显示查询结果(包括数据本身以及数据之间的层次关系)。树形结构的关系可以控制遍历树的方向，是自上而下，还是自下而上，还可以确定层次的开始点(ROOT)的位置。层次查询语句正是从这两个方面来确定的，START WITH确定开始点，CONNECT BY确定遍历的方向。树形结构的数据存放在表中，数据之间的层次关系即父子...
查询机构部门用户树
kingwolfs的博客
12-07 1286
首先说说我们的数据结构：机构表sys_organization(id,parent_organ,organ_simple_name,orderby) ,部门表sys_department(id,parent_department,sys_organization,department_name,orderby) (因为部门是挂在机构下面的，对于上级部门即parent_department为空的...
树形根据数据库查询的简单实例
weixin_44543135的博客
01-24 859
树形根据数据库查询的简单实例 开发工具与关键技术：Javascript + html5 作者：张金荣 撰写时间：2019年1月20日 树形数据与数据库这之间实现关联查询显示主要有三个层。一是在数据库建立数据库，格式如下图： 1、 该表要设置父ID（PaentsID）和子ID（SonID），树ID（TreeID） 父ID的ID为子ID的上级代码比如中国的父ID是0表示中国以上没有上级代码，广东省的...
有关树形结构的查询--Sql
SpringJava的博客
02-10 489
     树形结构是一类重要的非线性结构，在关系型数据库中如何对具有树形结构的表进行查询，从而得到所需的数据是一个常见的问题。     关系型数据库 将数据按表结构形式进行组织。它对表格的处理方便灵活，且易学易用，因而得到广泛的应用。关系型数据库所处理的表格是线性结构的，表的每一行对应着一个数据元素，称做一条记录。记录与记录之间呈线性排列，彼此间没有联系。    然而，在解决实际...
mysql树形结构单表查询
最新发布
09-18
MySQL树形结构单表查询可以通过自关联字段来实现。通常，表结构中包含id和parentId两个字段，其中id表示节点的唯一标识，parentId表示节点的父节点标识。下面给出两种方式的例子。 第一种方式是在程序中通过递归的...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值