SPACE() Function in MySQL

SPACE() function in MySQL is used to return a string consisting of specified empty space characters.

Syntax :

SPACE(num)

Parameter : This method accepts one parameter as mentioned above and described below :

• num : It is an integer which indicates how many spaces are being contained.

Returns : It returns the string containing of specified number spaces .

Example-1 : SPACE() Function to return a string containing only spaces.

SELECT SPACE(6) AS String_Name;

Output :

Example-2 : Applying SPACE() Function with CONCAT() Function return a string.

SELECT CONCAT('Beginner', SPACE(3), 'For', SPACE(3), 'Beginner') AS Company_Name;

Output :

Example-3 : Using SPACE() Function in a Table.

Table : Player_Details :

SELECT CONCAT(First_Name, SPACE(3), Last_Name) AS Full_Name FROM Player_Details ;

Output :