Re: Modify table structure

[Shantanu Oak]

create table new_table
select info1, info3 as info2, info2 as info3 from old_table;

drop table old_table;

rename table new_table to old_table;