concat()可以按顺序连接所有expression,分隔符空格作为一个string放在两个字段中间
select concat(last_name, " ", first_name) from employees
concat_ws()可以按顺序连接所有expression,第一个参数是连接符,所有expression之间插入连接符。
select concat_ws(" ", last_name, first_name) from employees
concat()可以按顺序连接所有expression,分隔符空格作为一个string放在两个字段中间
select concat(last_name, " ", first_name) from employees
concat_ws()可以按顺序连接所有expression,第一个参数是连接符,所有expression之间插入连接符。
select concat_ws(" ", last_name, first_name) from employees