alter table test_alter add user_name char(5), add address varchar(30);

 

 

insert into table_A([column],[column],[column])

select column,column,column

from table_B

where ...

order by ...