Most Efficient way to update one column

Hello,

 

I have a very large table. (120 million rows +). I want to update all the values in a single column.

 

what is the most efficient way of doing this?

 

I was thinking that I will create another table and then issue a update query based on join.

 

Is there a better / faster way? 

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file