(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

Let's Socialize

About Chillzee

Chillzee.com is an entrepreneurship portal.

The site provides informative topics on Organizational and Strategic needs.