CONCAT 连接符
案例:查询员工名和姓连接成一个字段,并显示为 姓名
SELECT CONCAT('a','b','c') AS 结果; # abc
SELECT
CONCAT(last_name, " ", first_name) AS 姓名
FROM
employees;
案例:查询员工名和姓连接成一个字段,并显示为 姓名
SELECT CONCAT('a','b','c') AS 结果; # abc
SELECT
CONCAT(last_name, " ", first_name) AS 姓名
FROM
employees;