SET FOREIGN_KEY_CHECKS = 0;
create table drizzle_user_bak2 like drizzle_user_bak;
ALTER TABLE drizzle_user_bak2 add COLUMN baby VARCHAR(20) DEFAULT NULL;
insert into drizzle_user_bak2(id,username,nickName) SELECT id,username,nickName from drizzle_user_bak;
RENAME TABLE drizzle_user_bak TO tmp, drizzle_user_bak2 to drizzle_user_bak;
drop table tmp;
SET FOREIGN_KEY_CHECKS = 1;
遗留问题:
1. 外键如何处理?
2.insert into A select from B 会不会锁死B?