space

Description

Syntax

VARCHAR space(Int num)

Returns a string consisting of num spaces.

example

1. mysql> select length(space(10));
2. +-------------------+
3. | length(space(10)) |
4. +-------------------+
5. |                10 |
6. +-------------------+
7. 1 row in set (0.01 sec)

9. mysql> select length(space(-10));
10. +--------------------+
11. | length(space(-10)) |
12. +--------------------+
13. |                  0 |
14. +--------------------+
15. 1 row in set (0.02 sec)

keywords

1. space