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)