RPAD() Function in MySQL

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

RPAD() Function in MySQL

jana_sayantan

Improve

Article Tags :

Similar Reads

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

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 :

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

POW() Function in MySQL

POW() function : This function in MySQL is used to return a results after raising a specified exponent number to a specified base number. For example if the base is 5 and exponent is 2, this will return a result of 25. Syntax : SELECT POW(x, y); Parameter : This method accepts two parameters as give

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

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

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

REPEAT() function in MySQL

REPEAT() : This function in MySQL is used to repeat a string a specified number of times. Syntax : REPEAT(str, count) Parameters : This method accepts two parameter. str -Input String which we want to repeat. count -It will describe that how many times to repeat the string. Returns : It returns a re

SIGN() Function in MySQL

SIGN() function in MySQL is used to return the sign of the given number. It returns 1 if the number is positive, -1 if the number is negative and 0 for zero. Syntax : SIGN(X) Parameter : SIGN() function accepts one parameter as input and will give you the results in values like Positive(+1),Negative

TIME() Function in MySQL

The TIME() function in MySQL is used to extract the time portion from a date or datetime expression, returning the time in the format 'HH:MM'. This function is particularly useful when working with time components in databases, such as scheduling or logging systems. In this article, We will learn ab