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

问题描述

我试图找到一种将两列合并为一列的方法，但继续将列中的值 '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)

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