How to create copy of one column in same table mysql [closed]

Question

I have a table with one columns of integer data type. I want to add another columns with string data type.

Finally I want to copy the values in first column to the second columns. That means I want to copy the integer data from column one and copy that to second column in string format.

Answer 1

Casting the column to a CHAR will do what you want:

UPDATE `table` SET column2 = CAST(column1 AS CHAR)