Mysql直接使用concat()连接字符串。

select concat(last_name," ",first_name) as Name
from employees