update

[raj123]

one of our client sent data in wrong columns

like instead of column1 data he sent to column 2 and vice-versa


is there any way i can update this data easily

like update tablname set column1=column2 and column2=column1



please let me know if it's possible

[sniper_v]

You should program a script that:
1) Copies the values of column 1 & column 2 into a temp table.
2) Deletes de values from the original table.
3) Copy from the temp table the values of column 1 and column 2 in the correct order.

Advice, if you have a primary key associated to each row, make sure each column value corresponds to the primary key you have.

[DaPi]

I've no db available to test . . . I suspect this could work:
update tablname set column1=column2, column2=column1
It's worth testing

[raj123]

thanks