MySQL中的字符串连接

Question

我正在使用MySQL和MySQL Workbench 5.2 CE。当我尝试连接2列last_name和时first_name，它不起作用：

select first_name + last_name as "Name" from test.student

Answer 1

MySQL与大多数DBMS使用+或||进行连接不同。它使用以下CONCAT功能：SELECT CONCAT(first_name, " ", last_name) AS Name FROM test.student正如@eggyal在注释中指出的那样，您可以||通过设置PIPES_AS_CONCATSQL模式在MySQL中启用与运算符的字符串连接。

Answer 2

尝试：select concat(first_name,last_name) as "Name" from test.student或更好：select concat(first_name," ",last_name) as "Name" from test.student