MySQL copy data from one column to another column

In this post, I will tell you MySQL copy data from one column to another column in the same table. and MySql update query to update record from one column to another column.

Sometimes you need to copy the whole column values to another in the same table. but is it possible in MySQL ?. Yes, it is possible in MySQL.

I have a table demo with id, column1, column2 and i want to copy value of column1 into column2.

UPDATE `demo` SET `column2`=`column1`

If you want to not copy 1 id column.

UPDATE `demo` SET `column2`=`column1` where `id`!=1