mysql GROUP_CONCAT重复项 [英] mysql GROUP_CONCAT duplicates

问题描述

我像这样从farmTOanimal表进行联接.有一个类似的farmTotool表

I make my join from a farmTOanimal table like this. There is a similar farmTotool table

id | FarmID  | animal
 1 |    1    | cat
 2 |    1    | dog

当我在视图中联接表时，得到的结果看起来像这样

When I join my tables in a view, I get a result that looks like this

FarmID | animal | tool
   1   |  cat   | shovel
   1   |  dog   | shovel
   1   |  cat   | bucket
   1   |  dog   | bucket

现在，我执行GROUP BY FarmID，GROUP_CONCAT(动物)和GROUP_CONCAT(工具)，我得到了

Now, I do GROUP BY FarmID, and GROUP_CONCAT(animal) and GROUP_CONCAT(tool), i get

FarmID |     animals     |         tools
  1    | cat,dog,cat,dog | shovel,shovel,bucket,bucket

但是，我真正想要的是一个看起来像这样的结果.我该怎么办?

But, what I really want is a result that looks like this. How can I do it?

FarmID | animals |    tools
  1    | cat,dog | shovel,bucket

推荐答案

您需要使用DISTINCT选项:

GROUP_CONCAT(DISTINCT animal)

这篇关于mysql GROUP_CONCAT重复项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！