MySQL 为生产环境在线添加字段

create table new_table_name like old_table_name;
alter table new_table_name add column new_column int not null default 0 comment 'your comment';

insert into new_table_name (col1, col2, col3...) select (col1, col2, col3...) from old_table_name where id < xxxx;

begin;
insert into new_table_name (col1, col2, col3...) select (col1, col2, col3...) from old_table_name where id >= xxxx
rename old_table_name to old_table_bak, new_table_name to old_table_name;
commit;
Contents
