- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
What happens if I pass only one argument to the MySQL CONCAT() function?
MySQL allows us to pass only one argument to the CONCAT() function. In this case, MySQL returns the same argument as output. Following example will exhibit it −
Example
mysql> Select Concat('Delhi');
+-----------------+
| Concat('Delhi') |
+-----------------+
| Delhi |
+-----------------+
1 row in set (0.00 sec)
- Related Articles
- What happens if we provide NULL as an argument to MySQL CHAR() function?
- What happens if a NULL argument is provided in MySQL CONV() function?
- What MySQL returns if we pass column name, containing a NULL value, as one of the arguments of CONCAT() function?
- What happens with the output of MySQL EXPORT_SET() function if I will skip the value of the fifth argument i.e. a number of bits?
- How to pass Python function as a function argument?
- Java Program to Pass ArrayList as the function argument
- Swift Program to Pass Dictionary as the function argument
- What happens with the output of MySQL EXPORT_SET() function if I will skip both 4th and 5th argument i.e. separator and number of bits?
- What MySQL returns if I provide a non-hexadecimal number as an argument to UNHEX() function?
- What MySQL returns if the argument of QUOTE() function is NULL?
- What happens if the argument ‘count’ in MySQL SUBSTRING_INDEX() function has the value greater than the total number of occurrences of delimiter?
- What happens if I will use integer values as arguments of MySQL LOCATE() 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?
- What is the range of date time value that we can pass as an argument to MySQL UNIX_TIMESTAMP function?
Advertisements