Mysql查询关系M-M表 [英] Mysql Query Relations M-M Table

问题描述

我有一个小问题在MySQL中进行查询。
我有以下表格：

• 成员;


• >
  
• member_has_group（此列的id_group表示组ID，id_member表示成员ID）

我试图做一个查询，给我的成员从一个选定的组。你能帮助我吗？

我不熟悉连接表，但对于搜索，我认为这可能是解决方案之一。

提前感谢。

Elkas

解决方案>

如果您知道群组ID

  select member。* from member m 
 inner join member_has_group mg on m.id = mg.id_member 
其中mg.id_group = [x] 
  

只知道群组名称

  select member。* from member m 
 inner join member_has_group mg on m.id = mg .id_member 
内部连接组g on g.id = mg.id_group 
其中g.name ='group name'
  

I'm having a small problem making a query in MySQL. I have the following tables:

• member;
• group;
• member_has_group (this one has the columns id_group referes to the group id and id_member referes to member id)

I'm trying to make a query that gives me the members from a selected group. Can you help me?

I'm not familiar with join tables, but for the search i made i think thats probably one of the solutions.

Thanks in advance.

Elkas

解决方案

If you know the group id

select member.* from member m
  inner join member_has_group mg on m.id = mg.id_member
where mg.id_group = [x]

If you only know the group name

select member.* from member m
  inner join member_has_group mg on m.id = mg.id_member
  inner join group g on g.id = mg.id_group
where g.name = 'group name'

这篇关于Mysql查询关系M-M表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！