SPACE(N)

If you want to add spaces in a string then you can use SPACE function of mysql. SPACE function returns a string consisting of N space characters means SPACE will returns the white space equal to passed argument n, where n is a integer value means if you passed 5 as argument with this function then this returns 5 spaces.

Here is a example-

mysql> SELECT SPACE(5);
+----------+
| SPACE(5) |
+----------+
|          |
+----------+
1 row in set (0.00 sec)

mysql> SELECT SPACE(15);
+-----------------+
| SPACE(15)       |
+-----------------+
|                 |
+-----------------+
1 row in set (0.00 sec)

mysql> SELECT SPACE(30);
+--------------------------------+
| SPACE(30)                      |
+--------------------------------+
|                                |
+--------------------------------+
1 row in set (0.00 sec)