Which function in MySQL is used to add white spaces between two strings?

MySQL SPACE() function is used to add white spaces between two strings. The argument passed in SPACE() function is an integer which specifies how many white spaces we want to add.

Syntax

SPACE(N)

Here, N is an integer specifies the number of white spaces we want to add.

Example

mysql> Select 'My Name is', Space(5), 'Ram';
+------------+----------+-----+
| My Name is | Space(5) | Ram |
+------------+----------+-----+
| My Name is |          | Ram |
+------------+----------+-----+
1 row in set (0.00 sec)

In the example above, SPACE() function adds 5 white spaces between the strings.

Swarali Sree

Published on 20-Feb-2018 11:57:49

• Related Questions & Answers
• MySQL BIT_LENGTH() function is used for which purpose?
• Which PHP function is used to select a MySQL database?
• Which PHP function is used to create a MySQL table?
• Which function in MySQL is used to reverse a particular string?
• Which PHP function is used to disconnect from MySQL database connection?
• Which PHP function is used to delete an existing MySQL table?
• How to add two or more strings in MySQL?
• How to compare two strings which are numbers in MySQL?
• How to check similarity between two strings in MySQL?
• Which PHP function is used to release cursor memory associated with MySQL result?
• Which PHP function is used to establish MySQL database connection using PHP script?
• Which PHP function is used to insert data into an existing MySQL table?
• For timestamp, which datatype is used in MySQL?
• Find a string in lexicographic order which is in between given two strings in Python
• How to remove white spaces for textview in Android?