MySQL8 SPACE() Functions – String Functions

by · Published · Updated

SPACE() Functions returns a string consisting of the blank space repeated count times.

If count is less than(<) 1, it returns an empty string. Returns NULL if argument is NULL.

Note : See also REPEAT() function.

MySQL SPACE() Functions: Syntax

SPACE ( count );

MySQL SPACE() Functions: Parameter

[table caption=”” width=”100%” colwidth=”15%|15%|15%|55%” colalign=”left|left|left|left”]
Name, Required /Optional,Type, Description
count, Required, String , It represents valid numeric value.
[/table]

MySQL SPACE() Functions: Output

[table caption=”” width=”100%” colwidth=”20%|80%” colalign=”left|left”]
Return, Description
Space character, repeated count times.
empty string, if count is less than(<) 1.
NULL, if argument is NULL.[/table]

MySQL SPACE() Functions: Available from

[table caption=”” width=”100%” colwidth=”25%|75%” colalign=”left|left”]
Version, MySQL 4.0
[/table]

SPACE() Example 1 : Very easy example

We will be repeating the space character string 2 times. Using  QUOTE() function to show it. Below is the example to show it. Single quote shows the space character.

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

SPACE() Example 2 : Using space with CONCAT() function

Below is the example where we will be repeating the input string 2 times.

mysql> SELECT CONCAT('mysql',SPACE(1),'tutorial!');
+--------------------------------------+
| CONCAT('mysql',SPACE(1),'tutorial!') |
+--------------------------------------+
| mysql tutorial!                      |
+--------------------------------------+
1 row in set (0.00 sec)

Some more examples :

mysql> SELECT CONCAT('This',SPACE(1),'is',SPACE(1),'tutorial!');
+---------------------------------------------------+
| CONCAT('This',SPACE(1),'is',SPACE(1),'tutorial!') |
+---------------------------------------------------+
| This is tutorial!                                 |
+---------------------------------------------------+
1 row in set (0.00 sec)

REPEAT() Example 3 : returns an empty string, if parameter is less than 1

If parameter is less than 1, returns an empty string. See below example :

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

mysql> SELECT QUOTE(SPACE(-1));
+------------------+
| QUOTE(SPACE(-1)) |
+------------------+
| ''               |
+------------------+
1 row in set (0.05 sec)

REPEAT() Example 4 : NULL arguments

If the arguments is NULL, it will return NULL. See below example :

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

See all MySQL String functions MySQL 8 String Functions.

Related articles : LOCATE(), HEX(), CONCAT(), CONCAT_WS() , LOWER(), LTRIM(), INSTR(), POSITION().

PHP Related articles : STR_REPEAT(), SUBSTR_COUNT(), SUBSTR_COMPARE(), SUBSTR_REPLACE(), STR_PAD(), PHP STRING FUNCTIONS().

You may also like...