SQLize Online / PHPize Online  /  SQLtest Online

SET @year=YEAR(CURDATE()); DROP FUNCTION IF EXISTS make_date; CREATE FUNCTION make_date (monthNum TINYINT) RETURNS DATE DETERMINISTIC RETURN CONCAT_WS('-', @year, monthNum, 1); WITH RECURSIVE months AS ( SELECT 1 as monthNum, MONTHNAME((SELECT make_date(1))) AS Month, EXTRACT(DAY FROM LAST_DAY((SELECT make_date(1)))) AS Days UNION ALL SELECT monthNum + 1, MONTHNAME((SELECT make_date(monthNum + 1))) AS Month, EXTRACT(DAY FROM LAST_DAY((SELECT make_date(monthNum + 1)))) AS Days FROM months WHERE monthNum < 12 ) SELECT Month, Days FROM months;