NUMBERS
numbers
description
表函数,生成一张只含有一列的临时表,列名为number
,如果指定了const_value
,则所有元素值均为const_value
,否则为[0,number
)递增。
syntax
numbers(
"number" = "n"
<, "const_value" = "x">
);
参数:
number
: 行数。const_value
: 常量值。
example
mysql> select * from numbers("number" = "5");
+--------+
| number |
+--------+
| 0 |
| 1 |
| 2 |
| 3 |
| 4 |
+--------+
5 rows in set (0.11 sec)
mysql> select * from numbers("number" = "5", "const_value" = "-123");
+--------+
| number |
+--------+
| -123 |
| -123 |
| -123 |
| -123 |
| -123 |
+--------+
5 rows in set (0.12 sec)
keywords
numbers, const_value