Collections:
CONCAT() - Concatenating Strings
How to concatenate multiple strings together using the CONCAT() function?
✍: FYIcenter.com
CONCAT(string1, string2, ...) is a MySQL built-in function that concatenates multiple strings together. For example:
SET @host = 'dba'; SET @domain = 'FYIcenter.com'; SELECT CONCAT(@host, '.', @domain); -- +-----------------------------+ -- | CONCAT(@host, '.', @domain) | -- +-----------------------------+ -- | dba.FYIcenter.com | -- +-----------------------------+
Reference information of the CONCAT() function:
CONCAT(str1, str2, ...): str Returns the string that results from concatenating the arguments. May have one or more arguments. If all arguments are nonbinary strings, the result is a nonbinary string. If the arguments include any binary strings, the result is a binary string. A numeric argument is converted to its equivalent nonbinary string form. Arguments, return value and availability: str1: Required. The first given string to concatenate for. str2: Optional. The second given string to concatenate for. str: Return value. The string of concatenation of all given strings. Available since MySQL 4.0.
Related MySQL functions:
⇒ CONCAT_WS() - Concatenation with Separator
⇐ COLLATION() - Detecting Character Collation Name
2023-11-10, 226🔥, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...