concat 用于连接

concat（字符1，字符2）
//若连接符号，用引号括起，如横杆 '-'


select concat(last_name,"'",first_name) as name
from employees