mysql - 如何将我的结果命名为其他名称

Question

我在 MYSQL 数据库中有一个这样的查询

SELECT date_format( doj, '%d/%m/%Y' ) AS week ,COUNT(user_id) FROm user_tb 
WHERE doj between '2012-01-01' AND '2012-01-31' group BY WEEK(doj)

Result

week    COUNT(user_id)
06/01/2012  3
17/01/2012  2
25/01/2012  3
29/01/2012  1

我怎么能这样命名呢

week    COUNT(user_id)
week1   3
week2   2
week3   3
week4   1

Answer 1

如果您想从 1 开始对周进行编号，请执行以下操作:

SELECT concat('week', @row := @row + 1) AS week, COUNT(user_id)
from user_tb, (select @row := 0) r
WHERE doj between '2012-01-01' AND '2012-01-31' 
group BY WEEK(doj)

编辑

如果你想要一年中的第几周，那么做:

SELECT concat('week', week(doj)) AS week, COUNT(user_id)
from user_tb, (select @row := 0) r
WHERE doj between '2012-01-01' AND '2012-01-31' 
group BY WEEK(doj)