How to copy all record from Column1 to Column2 of the same table?

Question

I added new column (DATE TIME) on my table and I put the same record on one column to the new column i recently added.

How can I copy all records from Column1 to Column2 of the same table?

score 2 · Accepted Answer · answered Oct 10 '19 at 06:02

2

do update

update table_name
set Column2=Column1

answered Oct 10 '19 at 06:02

1 Answers1