With

递归生成整数 1 到 10 。

WITH RECURSIVE t AS (
    SELECT 1 AS n
    UNION ALL
    SELECT n + 1 FROM t WHERE n < 10
)
SELECT n FROM t;

n
1
2
3
4
5
6
7
8
9
10

了解 CAST 四舍五入。

WITH RECURSIVE t (n, a, b, result) AS (
    SELECT 1 AS n, 20 AS a, 20 / 10 AS b, CAST(20 / 10 AS SIGNED INTEGER) AS result
    UNION ALL
    SELECT n + 1, a + 1, (a + 1) / 10, CAST((a + 1) / 10 AS SIGNED INTEGER) FROM t WHERE n < 21
)
SELECT * FROM t;

n	a	b	result
1	20	2.0000	2
2	21	2.1000	2
3	22	2.2000	2
4	23	2.3000	2
5	24	2.4000	2
6	25	2.5000	3
7	26	2.6000	3
8	27	2.7000	3
9	28	2.8000	3
10	29	2.9000	3
11	30	3.0000	3
12	31	3.1000	3
13	32	3.2000	3
14	33	3.3000	3
15	34	3.4000	3
16	35	3.5000	4
17	36	3.6000	4
18	37	3.7000	4
19	38	3.8000	4
20	39	3.9000	4
21	40	4.0000	4

With ​

With