SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE DateDimension ( DateID INT PRIMARY KEY AUTO_INCREMENT, Date DATE, Day INT, Month INT, Year INT, MonthName VARCHAR(15), Quarter INT, IsWeekend BOOLEAN ); WITH RECURSIVE DateRange AS ( SELECT CAST('2006-01-01' AS DATE) AS Date UNION ALL SELECT DATE_ADD(Date, INTERVAL 1 DAY) FROM DateRange WHERE Date < '2016-12-31' ) INSERT INTO DateDimension (Date, Day, Month, Year, MonthName, Quarter, IsWeekend) SELECT Date, DAY(Date), MONTH(Date), YEAR(Date), MONTHNAME(Date), QUARTER(Date), DAYOFWEEK(Date) IN (1, 7) FROM DateRange;