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)

Vikyath Ram

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?
• What MYSQL INTERVAL() function returns if there is no bigger number in the list of arguments than the number at first argument?
• Perform complex MySQL insert by using CONCAT()?
• 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
• When MySQL MAKE_SET() function returns NULL?
• When MySQL IN() function returns NULL?
• 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 MySQL returns if specified format string is not as per accordance with the date string passed as arguments to STR_TO_DATE() function?