我使用的是MySQL和MySQL Workbench 5.2CE。当我尝试连接两列,last_name
和first_name
时,它不起作用:
select first_name + last_name as "Name" from test.student
发布于 2011-05-12 17:31:37
发布于 2011-05-12 17:31:40
尝试:
select concat(first_name,last_name) as "Name" from test.student
或者,更好的是:
select concat(first_name," ",last_name) as "Name" from test.student
发布于 2011-05-12 17:31:48
使用concat()函数代替+
,如下所示:
select concat(firstname, lastname) as "Name" from test.student
https://stackoverflow.com/questions/5975958
复制相似问题