随笔分类 -  MySQL

MySQL生成指定月份所有日期列表
摘要：SELECT ADDDATE(month.firstDay, days.day - 1) AS monthDate FROM (SELECT 1 AS DAY UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SEL 阅读全文
posted @ 2024-09-12 10:49 小寒、 阅读(416) 评论(0) 推荐(0)