南国的刘新

摘要： -- 不依赖任何表，只是用mysql自带函数方法select concat((select year(now())),'-01') as `date`union select concat((select year(now())),'-02')union select concat((select 阅读全文

摘要： select date from (SELECT DATE_FORMAT(DATE_SUB(last_day(curdate()), INTERVAL xc-1 day), '%Y-%m-%d') as dateFROM ( SELECT @xi:=@xi+1 as xc from (SELECT 阅读全文