MySQL Mysql追加列值

Mysql append column value

提问by Aravindhan

I am having the table with the following structure

我有以下结构的表

      ----------------------------
       id                  content
      ---------------------------
        1                   abc
        2                   bca
      ---------------------------

I want to append the character 'd' with the field 'content' ... So i want the table structure as follows

我想在字段 'content' 中附加字符 'd' ... 所以我想要表结构如下

       ----------------------------
       id                  content
      ---------------------------
        1                   abcd
        2                   bca
      ---------------------------

How can i do this..

我怎样才能做到这一点..

回答by Dhinakar

If you want update the column from the Table then use below Query

如果要更新表中的列，请使用下面的查询

update table1 set content = concat(content,'d');

If you want to select the column concatenation with 'd; the use below Query

如果要选择带有 'd; 的列连接；下面使用查询

select id, concat(content,'d') as content from table1;

Refer :

参考 ：

http://sqlfiddle.com/#!2/099c8/1

http://sqlfiddle.com/#!2/099c8/1

回答by Mahmoud Gamal

You can use the CONCAT, like so

你可以CONCAT像这样使用

SELECT 
  id,
  CONCAT(content, 'd') content
FROM tablename;

You can also specify a WHEREclause to determine which rows to update. Something like:

您还可以指定一个WHERE子句来确定要更新哪些行。就像是：

SELECT 
  id,
  CONCAT(content, 'd') content
FROM tablename
WHERE id = 1;