- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- 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)
Published on 19-Feb-2018 14:16:48
- Related Questions & Answers
- 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 returns if the argument of QUOTE() function is NULL?
- Perform complex MySQL insert by using CONCAT()?
- What MYSQL INTERVAL() function returns if there is no bigger number in the list of arguments than the number at first argument?
- When MySQL MAKE_SET() function returns NULL?
- When MySQL IN() function returns NULL?
- What MySQL returns if we use NULL, as both the arguments, as one of the argument and as a separator, in CONCAT_WS() function?
- Passing Arguments to a Subroutine in Perl
- Passing arguments to a Tkinter button command
- What MySQL EXPORT_SET() function returns if any of the argument is NULL?
- What MySQL returns if the first argument of INTERVAL() function is NULL?
- What happens if I pass only one argument to the MySQL CONCAT() function?
Advertisements