MySQL8使用with recursive实现递归
MySQL8使用with recursive实现递归输出1 ~ nWITH recursive t AS ( SELECT 1 AS n UNION ALL SELECT n + 1 FROM t WHERE n < 10) SELECT * FROM t;输出n的阶乘WITH recursive t AS ( SELECT 1 AS n, 1 AS factorial UNION ALL SELECT n + 1, ( n + 1 ) * factorial
原创
2021-08-24 20:01:33 ·
3815 阅读 ·
0 评论