在mysql中显示月份名称而不是月份编号

本文介绍了在mysql中显示月份名称而不是月份编号的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

编写查询以显示月份名称和 2013 年每个月安排的事件数，按月份排序.为月份名称指定一个别名为 month_name，为计划的事件数指定一个别名为 number_of_events.月份名称必须显示为一月、二月...我尝试了以下查询，但没有执行:

Write a query to display the name of the month and the number of events scheduled in each month in the year 2013, sorted by month. Give an alias to the month name as month_name and the to the number of events scheduled as number_of_events. Name of the month must be displayed as January, February ... I tried the following query but its not executing:

select convert(varchar(10),month,date) as month_name, count(*) as number_of_events from event where year(date)=2013 group by date order by date ;

表名:

event

列:

id bigint(20) primary key date datetime description varchar(255) invitation varchar(255) name varchar(255) organiser_id bigint(20)

推荐答案

你应该使用 MONTHNAME(date) - 像这样:

You should use MONTHNAME(date) - something like this:

select MONTHNAME(date),COUNT(*) from event where year(date)=2013 group by MONTH(date)