Binoy asked this 4 years ago

Copy data from one column to another in MySQL

I have a table with 3 columns, say col1, col2, col3

I want to copy all the data from col2 to col3, how can i do that?

Best Answer by Prem 4 years ago

To copy all values from col2 to col3

UPDATE table_name SET col3=col2;