update one column from another column in same table

Solutions on MaxInterview for update one column from another column in same table by the best coders in the world

Search
showing results for - "update one column from another column in same table"
Clara
26 Nov 2017
1select * from stuff
2
3update stuff
4set TYPE1 = TYPE2
5where TYPE1 is null;
6
7update stuff
8set TYPE1 = TYPE2
9where TYPE1 ='Blank';
10
11select * from stuff
12
source
similar questions
sql update multiple columns from another tablemysql update one table from another table multiple columnssql server update multiple columns at onceupdate multiple columns in sqlsql get all columns from one table but one from another inner joinsql update from different tablecopy one column data to another in sqlmysql update column with value from another tableupdate query for multiple columnssql server update column based on another tablecopy all values of a column to another column in sql in same table
queries leading to this page
change value of one column based on another columnupdate column value based on another column in same tablesql update value from one column to another column in the same tableupdate column based on another column which is present another table sqlupdate column with another column in same table sqlupdate value of one column to another column in sqlupdate single column in a table with different values based on values of another columnsql update column with value from other columns in the same tableupdate one table column from another table column in sqlupdate one column from another column in same tablesql update column with value from another column in the same tablesql update column with another columnupdate one column from another column in same table