外贸网站运营怎么做,vi品牌包装,seo推广视频隐迅推专业,凡科网站开发要按时间戳字段按月份分组查询记录表#xff0c;可以使用DATE_FORMAT函数将时间戳字段格式化为年月格式#xff0c;然后将结果按照该字段进行分组。
SELECT a.month month,ifnull(b.count, 0) count FROM (SELECT 1 month UNION ALL SELECT 2 month UNION ALL SELECT 3 mont…要按时间戳字段按月份分组查询记录表可以使用DATE_FORMAT函数将时间戳字段格式化为年月格式然后将结果按照该字段进行分组。
SELECT a.month month,ifnull(b.count, 0) count FROM (SELECT 1 month UNION ALL SELECT 2 month UNION ALL SELECT 3 month UNION ALL SELECT 4 month UNION ALLSELECT 5 month UNION ALL SELECT 6 month UNION ALL SELECT 7 month UNION ALL SELECT 8 month UNION ALL SELECT 9 month UNION ALLSELECT 10 month UNION ALL SELECT 11 month UNION ALL SELECT 12 month) a LEFT JOIN(SELECT DATE_FORMAT(FROM_UNIXTIME(create_time), %m) AS month, COUNT(*) AS count
FROM user_log
GROUP BY month) bON a.monthb.month ORDER BY month
