mysql concat
The CONCAT function in MySQL is used to concatenate two or more strings together.
Here is the syntax for using CONCAT:
CONCAT(string1, string2, ...)
Example:
SELECT CONCAT('Hello', ' ', 'World') AS result;
This will output "Hello World".
You can also use CONCAT with column names:
SELECT CONCAT(first_name, ' ', last_name) AS full_name FROM customers;
This will concatenate the first_name and last_name columns from the customers table and output the full name for each row.
原文地址: https://www.cveoy.top/t/topic/iGwJ 著作权归作者所有。请勿转载和采集!