2020. 1. 14. 16:28
SELECT dt + INTERVAL lv-1 DAY dt
FROM (
SELECT @ROWNUM:=@ROWNUM+1 AS lv
, CONCAT('202001','01') dt
FROM information_schema.`COLUMNS` A
, (SELECT @ROWNUM:=0) R
LIMIT 100
) a