交互式爱情
讨厌这样说,但是没有这个功能的四巨头中MySQL唯一RDBMS。在Oracle:SELECT *FROM dualCONNECT BY
level
(
SELECT 1
UNION ALL
SELECT row + 1
FROM hier WHERE row
(
SELECT 1
UNION ALL
SELECT row + 1
FROM hier WHERE row
)SELECT *FROM hierOPTION (MAXRECURSION 32767) -- 32767 is the maximum value of the hint在PostgreSQL:SELECT *FROM generate_series (1, n)在MySQL,什么都没有。