How to create copy of one column in same table mysql

mysql, sql

Solution

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

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

Problem

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.

Original source