MySQL 将两列合并为一列
我试图找到一种将两列合并为一列的方法，但继续将列中的值 '0' 改为单词的组合.
I'm trying to find a way to combine two columns into one, but keep getting the value '0' in the column instead to the combination of the words.
这些是我和其他人都尝试过的:
These are what I've tried as well as others:
SELECT column1 + column2 AS column3
FROM table;
SELECT column1 || column2 AS column3
FROM table;
SELECT column1 + ' ' + column2 AS column3
FROM table;
有人能告诉我我做错了什么吗?
Could someone please let me know what I'm doing wrong?
推荐答案
我猜您正在使用 MySQL，其中 + 运算符执行加法，以及将值静默转换为数字.如果值不以数字开头，则转换后的值为 0.
My guess is that you are using MySQL where the + operator does addition, along with silent conversion of the values to numbers. If a value does not start with a digit, then the converted value is 0.
试试这个:
select concat(column1, column2)
添加空格的两种方法:
select concat(column1, ' ', column2)
select concat_ws(' ', column1, column2)
相关文章