本文介绍了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)
这篇关于MySQL 将两列合并为一列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！
本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除！