Tagged Questions
2
votes
1answer
216 views
How do you convert IBM DB2's recursive increment to MySQL version?
DB2 Queries:
WITH
TABLE1 (YEAR_END) as( VALUES
(2011))
,
TABLE2
(YEAR_END) AS ( VALUES(2011))
,
TABLE3 (YEARS) AS ( SELECT 0+2008 FROM TABLE1 T1, TABLE2 T2
union ...