年月MYSQL

WITH RECURSIVE  
numbers(n) AS (  
    VALUES (0), (1), (2), (3), (4), (5), (6), (7), (8), (9)  
),  
dates AS (  
    SELECT   
        datetime('1970-01-01', '+' || (t2.n * 100 + t1.n * 10 + t0.n) || ' months') AS date  
    FROM   
        numbers t0,   
        numbers t1,   
        numbers t2  
)  
 
SELECT   
    strftime('%Y-%m', date) AS yearAndMonth  
FROM   
    dates  
WHERE   
    date BETWEEN datetime('${task_start}') AND datetime('${task_end}')  
ORDER BY   
    yearAndMonth ASC;