MySQL 中的字符串连接

2021-11-20 00:00:00 concat mysql mysql-workbench

我使用的是 MySQL 和 MySQL Workbench 5.2 CE.当我尝试连接 2 列 last_name 和 first_name 时，它不起作用:

I am using MySQL and MySQL Workbench 5.2 CE. When I try to concatenate 2 columns, last_name and first_name, it doesn't work :

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

推荐答案

MySQL 与大多数 DBMS 使用 + 或 || 进行连接不同.它使用 CONCAT 功能:

MySQL is different from most DBMSs use of + or || for concatenation. It uses the CONCAT function:

SELECT CONCAT(first_name, " ", last_name) AS Name FROM test.student

正如@eggyal 在评论中指出的，您可以通过设置 PIPES_AS_CONCAT SQL 模式.

As @eggyal pointed out in comments, you can enable string concatenation with the || operator in MySQL by setting the PIPES_AS_CONCAT SQL mode.

相关文章