numbers

description

Table function that generates a temporary table containing only one column with the column name number and all element values are const_value if const_value is specified, otherwise they are [0,number) incremented.

syntax

numbers(
  "number" = "n"
  <, "const_value" = "x">
  );

parameter：

• number: Line number.
• const_value: the constant 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