- 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
What MySQL CONCAT() function returns by passing the numeric arguments?
MySQL allows us to pass numeric arguments to CONCAT() function. It can be passed without using the quotes.
Example
mysql> Select Concat(10,20); +---------------+ | Concat(10,20) | +---------------+ | 1020 | +---------------+ 1 row in set (0.00 sec)
Even we can pass one character string argument and one numeric argument to CONCAT() function as follows −
mysql> Select CONCAT('DELHI ', 110006)AS 'City PIN CODE';
+----------------+
| City PIN CODE |
+----------------+
| DELHI 110006 |
+----------------+
1 row in set (0.00 sec)
- Related Articles
- What MySQL returns if we pass column name, containing a NULL value, as one of the arguments of CONCAT() function?
- What MySQL COALESCE() function returns if all the arguments provided to it are NULL?
- What MySQL returns on passing an invalid string as an argument to STR_TO_DATE() function?
- Passing unknown number of arguments to a function in Javascript
- What MYSQL INTERVAL() function returns if there is no bigger number in the list of arguments than the number at first argument?
- What MySQL returns if specified format string is not as per accordance with the date string passed as arguments to STR_TO_DATE() function?
- What MySQL returns if we use NULL, as both the arguments, as one of the argument and as a separator, in CONCAT_WS() function?
- What MySQL returns if the argument of QUOTE() function is NULL?
- When MySQL IN() function returns NULL?
- When MySQL MAKE_SET() function returns NULL?
- What happens if I pass only one argument to the MySQL CONCAT() function?
- What MySQL returns if the first argument of INTERVAL() function is NULL?
- What MySQL EXPORT_SET() function returns if any of the argument is NULL?
- Which function in MySQL returns the same output as BIN() function?
- Perform complex MySQL insert by using CONCAT()?
Advertisements