Mysql再次分组并显示其余行 [英] Mysql again, group by and display rest of rows
本文介绍了Mysql再次分组并显示其余行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有table:
id,day,user,value,active
现在我得到
从ppl GROUP BY用户中选择一天
但是!我想把所有的日子都放在一行中,而不仅仅是一个例如
例如
day:1,2 ,3,4,5,6,7,8,9 ...
用户:myusername
有可能吗?
是的,
选择
用户,
GROUP_CONCAT(日)
FROM ppl
GROUP BY 1;
是我的问题的答案,但是我有下一个,最后一个
以下是查询结果
http://screenshooter.net/0562655/ 24_05_2012__22_37_09
如何更改
row 3 from 8,9,10至8-10
排5从21,22,23,24,28,29,30至21-24,28-30
排自17,21,22, 23,24,25至17,21-25
?
<选择
的用户,
GROUP_CONCAT(日)天
FROM ppl
GROUP BY 1;
I have table:
id, day, user, value, active
And now i get SELECT day from ppl GROUP BY user
but! i want to get all days in one row, not only one
for example
day: 1,2,3,4,5,6,7,8,9... user: myusername
is it possible?
Yep,
SELECT
user,
GROUP_CONCAT(day) day
FROM ppl
GROUP BY 1;
Is answer for my question, but i've got next, last
Here is result of query http://screenshooter.net/0562655/24_05_2012__22_37_09
how to change
row 3 from 8,9,10 to 8-10
row 5 from 21,22,23,24,28,29,30 to 21-24,28-30
row 6 from 17,21,22,23,24,25 to 17,21-25
?
解决方案
SELECT
user,
GROUP_CONCAT(day) day
FROM ppl
GROUP BY 1;
这篇关于Mysql再次分组并显示其余行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文