MySQL将两列合并为一列 [英] MySQL combine two columns into one column

问题描述

我正在尝试找到一种将两列合并为一个的方法，但始终在列中获取值'0'而不是单词的组合.

这些是我以及其他人尝试过的:

SELECT column1 + column2 AS column3
FROM table;

SELECT column1 || column2 AS column3
FROM table;

SELECT column1 + ' ' + column2 AS column3
FROM table;

有人可以让我知道我在做什么错吗?

我的猜测是您正在使用MySQL，其中+运算符会进行加法运算，以及将值自动转换为数字.如果值不是以数字开头，则转换后的值为0.

所以尝试一下:

select concat(column1, column2)

两种添加空格的方法:

select concat(column1, ' ', column2)
select concat_ws(' ', column1, column2)

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?

解决方案

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.

So try this:

select concat(column1, column2)

Two ways to add a space:

select concat(column1, ' ', column2)
select concat_ws(' ', column1, column2)

这篇关于MySQL将两列合并为一列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！