SELECT create_time,from_unixtime(create_time) as create_date,MONTH(from_unixtime(`create_time`)) AS monthNo,
YEAR(from_unixtime(`create_time`)) AS myYear,
title
FROM unsun_article
GROUP BY DATE_FORMAT(from_unixtime(create_time),'%Y-%m')
根据create_time查询所有的年月数据,把时间戳转换成日期格式查询,from_unixtime把时间戳转换成日期格式,YEAR()获取日期中的年份,MONTH()获取日期中的月份,根据月份分组数据查询