dongya6997 2019-05-18 17:49 采纳率: 0%
浏览 44
已采纳

如何在mysql中进行查询选择父和子而不重复父行

I would like to obtain the table data and the data of the children are in another table but I do not know how to make the query.

what I know how to do is a normal query select * form table 1, I know how to perform "inner join" but I do not want the data in table 1 "parent" repeated

select * form parent INNER JOIN childs on parent.pnt_id=childs.id_pnt;

parent childs

+-----+----------+------+-------+   +-----+----------+-------+  
| id  |   pnt_id | info |infotwo|   | id  |   id_pnt |n_child|...  
+-----+----------+------+-------+   +-----+----------+-------+  
|    1|         5| home | big   |   |    5|         1|  joan | 
+-----+----------+------+-------+   +-----+----------+-------+  
|    2|         3| work | fat   |   |    3|         1|  luci |  
+-----+----------+------+-------+   +-----+----------+-------+  
|    3|         0| soft |  thin |   |    6|         2|  troy |  
+-----+----------+------+-------+   +-----+----------+-------+

I would like a query in the form of

$parents = arrar (
          info -> "home",
          infotwo -> "big",
          data_child -> arrar (
                      n_child -> "joan",
                      n_child -> "luci"
                     )
)
  • 写回答

1条回答 默认 最新

  • duanlan5320 2019-05-18 19:27
    关注

    I think you want aggregation:

    select p.info, p.infotwo, group_concat(n_child) as children
    from parent p join
         childs c
         on p.pnt_id = c.id_pnt
    where p.pnt_id = 1
    group by p.info, p.infotwo;
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
编辑
预览

报告相同问题?

悬赏问题

  • ¥15 PADS Logic 原理图
  • ¥15 PADS Logic 图标
  • ¥15 电脑和power bi环境都是英文如何将日期层次结构转换成英文
  • ¥20 气象站点数据求取中~
  • ¥15 如何获取APP内弹出的网址链接
  • ¥15 wifi 图标不见了 不知道怎么办 上不了网 变成小地球了
手机看
程序员都在用的中文IT技术交流社区

程序员都在用的中文IT技术交流社区

专业的中文 IT 技术社区,与千万技术人共成长

专业的中文 IT 技术社区,与千万技术人共成长

关注【CSDN】视频号,行业资讯、技术分享精彩不断,直播好礼送不停!

关注【CSDN】视频号,行业资讯、技术分享精彩不断,直播好礼送不停!

客服 返回
顶部