SPACE() Function in MySQL

Last Updated : 24 Sep, 2020

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 :

String_Name

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

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

Output :

Company_Name
Geeks For Geeks

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

Player_Id	First_Name	Last_Name
101	Virat	Kohli
102	Rohit	Sharma
103	Sikhar	Dhawan

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

Output :

Full_Name
Virat Kohli
Rohit Sharma
Sikhar Dhawan

SUBDATE() function in MySQL

jana_sayantan

Improve

Article Tags :

Similar Reads

REPLACE() Function in MySQL

The REPLACE() function in MySQL is a powerful tool for string manipulation, allowing users to substitute specific substrings within a larger string. This functionality is particularly useful in various applications such as updating text data, cleaning up input or adjusting content in a database. In

3 min read

RPAD() Function in MySQL

RPAD() function in MySQL is used to pad or add a string to the right side of the original string. Syntax : RPAD(str, len, padstr) Parameter : This function accepts three parameter as mentioned above and described below : str : The actual string which is to be padded. If the length of the original st

1 min read

SUBDATE() function in MySQL

SUBDATE() function in MySQL is used to subtracts a time value (as interval) from a given date. Syntax : SUBDATE(date, INTERVAL expr unit) Parameter : This function accepts three parameters as given below : date : First specified date. expr : The value of the time/date interval to subtract. unit : Th

2 min read

PI() function in MySQL

PI() function in MySQL is used to return the Pi value. The default number of decimal places displayed is seven, but MySQL uses the full double-precision value internally. Syntax : PI() Parameter : This method does not accept any parameter. Returns : It returns the Pi value i.e. 3.141593. Example-1 :

2 min read

POWER() Function in MySQL

POWER() function in MySQL is used to find the value of a number raised to the power of another number. It Returns the value of X raised to the power of Y. Syntax : POWER(X, Y) Parameter : This method accepts two parameter which are described below : X : It specifies the base number. Y : It specifies

3 min read

SUM() Function in MySQL

The SUM() function in MySQL is a powerful aggregate function used to calculate the total sum of values in a numeric column. By summing up the values in the specified column, this function helps in generating overall totals and performing calculations that provide meaningful insights from our data. I

4 min read

TAN() Function in MySQL

TAN() function : This function in MySQL is used to return the tangent of a specified number. In any right triangle, the tangent of an angle is the length of the opposite side divided by the length of the adjacent side. Similarly, this can also be defined as tangent of x is the sine of x divided by t

1 min read

OCT() function in MySQL

OCT() function in MySQL is used to convert decimal number to octal. It returns equivalent octal value of a decimal number. Syntax : OCT(number) Parameter : This method accepts only one parameter. number : The decimal number which we want to convert. Returns : It returns octal value of a decimal numb

2 min read

SECOND() Function in MySQL

SECOND() function in MySQL is used to return the second portion of a specified time or date-time value. The first parameter in this function will be the date/Date Time. This function returns the seconds from the given date value. The return value (seconds) will be in the range of 0 to 59. In this fu

2 min read

STRCMP() Function in MySQL

STRCMP() function in MySQL is used to compare two strings. If both of the strings are same then it returns 0, if the first argument is smaller than the second according to the defined order it returns -1 and it returns 1 when the second one is smaller the first one. Syntax : STRCMP(Str1, Str2) Param

3 min read