Update a column of a table with append some values to the same column value in MySQL

Question

Lock issue occurred when i tried to update a Column of a table with concatenate the same column value with some characters.

UPDATE Templates 
   SET TemplateName = CONCAT("'", (SELECT TemplateName 
                                           FROM Templates 
                                          WHERE LogID = 2), '_Validated',"'")
 WHERE LogID = 2;

Is there any possible ways to achieve this?

OMG Ponies · Accepted Answer · 2011-10-22 06:13:18Z

4

Use:

UPDATE TEMPLATES
   SET TemplateName = CONCAT("'", templatename, '_Validated')
 WHERE LogID = 2

edited Oct 22, 2011 at 6:13

answered Oct 22, 2011 at 6:08

OMG Ponies

334k85 gold badges536 silver badges508 bronze badges

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

1 Comment

Tanya Over a year ago

Thanks for your immediate reply..Sorry i have mistaken the code.. both are the same tables.. kindly saw the updated code :)

Collectives™ on Stack Overflow

Update a column of a table with append some values to the same column value in MySQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest