Binoy asked this 2 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?


Prem 2 years ago

To copy all values from col2 to col3

UPDATE table_name SET col3=col2;