create table userinfo_new as select * from userinfo_old.
select * from userinfo_new.
create table userinfo_new as select id,username from userinfo_old.
insert into table userinfo_new(id,username) select id,username from username.
select * from userinfo_new.
create table userinfo_new as select id,username from userinfo_old.
insert into table userinfo_new(id,username) select id,username from username.
2017-03-16