mysql 递归 recursive 斐波那契数列 生成连续日期

连续日期这个比较有用，做过ERP的都知道，有些报表，就是要先生成连续日期。

比如老板要看某个物料按天库存消耗情况，按天订单等。

#斐波那契数列
WITH RECURSIVE fibonacci (n, fib_n, next_fib_n) AS
(
SELECT 1, 0, 1
UNION ALL
SELECT n + 1, next_fib_n, fib_n + next_fib_n
FROM fibonacci WHERE n < 10
)
SELECT * FROM fibonacci;

#生成连续日期
WITH RECURSIVE dates (date) AS
(
SELECT '2023-05-08' date FROM dual
UNION ALL
SELECT date + INTERVAL 1 DAY FROM dates
WHERE date + INTERVAL 1 DAY <= (SELECT '2023-12-31' FROM dual)
)
SELECT * FROM dates;