SELECT date FROM
(select`在这里插入代码片`
DATE_ADD(t1.dayed,INTERVAL t2.number DAY) date from
(select DATE_ADD(curdate(),interval -day(curdate())+1 day) dayed) t1,(SELECT @xi:=@xi+1 as number from
(SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4) xc1,(SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8) xc2,(SELECT @xi:=-1) xc0 ) t2
where DATE_ADD(t1.dayed ,INTERVAL t2.number DAY))time WHERE SUBSTRING(date,1,7)=SUBSTRING(CURDATE(),1,7)
Java开发中 超实用的Sql语法使用Sql语句实现,查询获取当前月份的每一天的日期字符串集合使用Sql语句实现,查询获取当前月份的每一天的日期字符串集合 SELECT date FROM (select`在这里插入代码片` DATE_ADD(t1.dayed,INTERVAL t2.number DAY) date from (select DATE_ADD(curdate(),interval -day(curdate())+1 day) d