Jump to: navigation, search

Mysql SPACE

From w3cyberlearnings

Contents

MySQL SPACE Function

This function returns space of N characters.

Syntax SPACE

  • N is the total space to be return
SPACE(N);

Example 1

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

Example 2

mysql> SELECT 'good',SPACE(6),'bad';
+------+----------+-----+
| good | SPACE(6) | bad |
+------+----------+-----+
| good |          | bad |
+------+----------+-----+
1 row in set (0.00 sec)

Related Links


Navigation
Web
SQL
MISC
References