concat拼接字段

1
select concat(firstname, '.', lastname) as name from user;

使用别名

1
select username as name from user;