Re: move data to diffrent field in multiple rows

[Peter Brawley]

> update table1 set
> a = b
> , b = a

Unfortunately that will set a to b and leave b as is, you need a swap column ...

-- add swap column
alter table add column swap (same type as a & b)

-- standard swap 3-stepswap
alter table table1 set swap=a, a=b, b=swap;

-- check
select a,b from table1;

-- lose the swap col
alter table table1 drop column swap;