- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
- Related Articles
- How to add two or more strings in MySQL?
- How to Add Spaces between Numbers in Excel?
- Which function in MySQL is used to reverse a particular string?
- How to check similarity between two strings in MySQL?
- 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?
- How to compare two strings which are numbers in MySQL?
- 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 dividers and spaces between items in RecyclerView?
- Program to add two binary strings in C++
- How to add Two Binary Strings in Golang?
- Java Program to Add Two Binary Strings
- How to remove white spaces for textview in Android?

Advertisements