mysql concat()函数

select concat(e.last_name,' ',e.first_name) from employees e;