MySQL、SQL Server、Oracle等数据库支持CONCAT方法,Mysql数据库可以使用CONCAT或者CONCAT_WS两种函数进行拼接
select CONCAT(last_name," ",first_name) as name from employees
MySQL、SQL Server、Oracle等数据库支持CONCAT方法,Mysql数据库可以使用CONCAT或者CONCAT_WS两种函数进行拼接
select CONCAT(last_name," ",first_name) as name from employees