知识点

  1. 连接使用concat(字段1,字段2,……)
  2. 因为连接使用的引号所以可以使用""或者转义字符\进行区分

代码

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