mysql - Update column with value from another column

Question

In a SQL table I have two columns: the first contain a path and the second contains a value.

colunm1	/path/
colunm2	12345

Answer 1

You have to use CONCAT

update tablename p
set p.colunm1 = CONCAT("/path/",`colunm2`,"/");