Question

我有一张桌子:

id, 日、用户、值、活动

And now i get SELECT day from ppl GROUP BY user

但是! 我想排成一排,不只排成一排

例如,例如

day: 1,2,3,4,5,6,7,8,9... user: myusername

有可能吗?????

没错,

SELECT
     user,
     GROUP_CONCAT(day) day
 FROM ppl
 GROUP BY 1;

是回答我的问题, 但我得到了下一个,最后一个,

如何改变变化

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

?????

Answer 1

 SELECT
     user,
     GROUP_CONCAT(day) day
 FROM ppl
 GROUP BY 1;