(Reading time: 1 minute)

 MySql

To update a column using the values from another column in the same table, use the following query:

 
 
 
Update Table_Name Set Column1 = Column2
 
 
 

 

Where,

Table_name is the Table to be updated

Column1 is the colum that needs to be updated

Column 2 is the column from which the value needs to be taken

 


Chillzee Tag Cloud

About Chillzee

Chillzee.com is an entrepreneurship portal.

The site provides informative topics on Organizational and Strategic needs.