MySQL: update column with data from another column

Question

I am trying to fix some wrongly placed data for a pretty important column in my table. The data in Column1 should be in Column2, however, I need to update Column2 with Column1 data for each row up until a date, say 2020-10-20.

Any suggestions on how to do this safely?

My two columns:

Column1  Column2
150      -0.5
151      -0.13
155.5    10.33
165.4    1.1

nbk · Accepted Answer · 2020-10-25 20:30:44Z

1

You can do it like this

UPDATE Table1 SET Column2 = Column1 WHERE mydayte <= '2020-10-20'

answered Oct 25, 2020 at 20:30

nbk

49.6k8 gold badges32 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

massideux Over a year ago

Worked great it seems, safe and sound. Thanks!

Collectives™ on Stack Overflow

MySQL: update column with data from another column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related