Thursday, January 9, 2014
Updating column 1 or column 2 with value of same column value or different column value of same table
Some time we need to change values of columns of same row of a table.
update table_name set column1 = column2
you can also put some arithmetic calculation and update table as well. the above query will take the value of column2 and will store it in the column1 of the same row of same table.