如何在MySQL中生成一个到10的平方数序列?(1^2,2^2等)
我只能生成一个从1到10的数字序列.
WITH RECURSIVE cte (n) AS
(
SELECT 1
UNION ALL
SELECT (n + 1) FROM cte WHERE n < 10
)
SELECT n FROM cte;
但是如果我添加POW()函数,结果将是
WITH RECURSIVE cte (n) AS
(
SELECT 1
UNION ALL
SELECT POW((n + 1),2) FROM cte WHERE n < 10
)
SELECT n FROM cte;
结果: 1 4. 25个