MySQL update column based on another column data manipulation

Question

I have a table looks like below:

id  name  value    newColumn
============================
1   Joe     22     null
2   Derk    30     null

newColumn is a newly added column and I would like to update the data for each and every rows with a specific format: concat value and a specific string -CIF

End result should be something like below:

id  name  value    newColumn
============================
1   Joe     22     22-CIF
2   Derk    30     30-CIF

May I know how to construct such update query in mySQL?

Gordon Linoff · Accepted Answer · 2015-03-11 01:47:47Z

2

This is a fairly basic update:

update table t
    set newColumn = concat(value, '-CIF');

answered Mar 11, 2015 at 1:47

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

peterh Over a year ago

Well, I gave you almost a "code snippet is not enough" comment and a vtd :-)

Collectives™ on Stack Overflow

MySQL update column based on another column data manipulation

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related