如何批量更改mysql库中100张表的字段位数

[root@db-master ~]# sh alter_table.sh

alter table user_campaign_0 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

0 finished.

alter table user_campaign_1 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

1 finished.

alter table user_campaign_2 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

2 finished.

alter table user_campaign_3 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

3 finished.

alter table user_campaign_4 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

4 finished.

alter table user_campaign_5 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

5 finished.

alter table user_campaign_6 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

6 finished.

alter table user_campaign_7 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

7 finished.

alter table user_campaign_8 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

8 finished.

alter table user_campaign_9 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

9 finished.

alter table user_campaign_10 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

10 finished.

alter table user_campaign_11 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

11 finished.

alter table user_campaign_12 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

12 finished.

alter table user_campaign_13 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

13 finished.

alter table user_campaign_14 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

14 finished.

alter table user_campaign_15 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

15 finished.

alter table user_campaign_16 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

16 finished.

alter table user_campaign_17 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

17 finished.

alter table user_campaign_18 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

18 finished.

alter table user_campaign_19 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

19 finished.

alter table user_campaign_20 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

20 finished.

alter table user_campaign_21 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

21 finished.

alter table user_campaign_22 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

22 finished.

alter table user_campaign_23 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

23 finished.

alter table user_campaign_24 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

24 finished.

alter table user_campaign_25 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

25 finished.

alter table user_campaign_26 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

26 finished.

alter table user_campaign_27 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

27 finished.

alter table user_campaign_28 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

28 finished.

alter table user_campaign_29 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

29 finished.

alter table user_campaign_30 modify current_stage mediumint(6) unsigned not null default 0 comment '当前关卡';

30 finished.

（编辑：滁州站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!