给mysql大表添加字段

create table user_bak like user;

alter table user_bak add column `unit` int(10) DEFAULT 1;  
  
INSERT INTO user_bak(`id`, `usn`, `pwd`, `name`, `qq`) select * from user;  
  
rename table `user` to user_bak2;  
  
rename table user_bak to user;