drop new column;
make an import;
create table nw as select id,name from tb;
truncate tb;
add to tb column 'num';
insert into tb select id,name,'value' from nw;