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

如何批量更改mysql库中100张表的字段位数2014-06-23输入查看当前库中表的字段位数： mediumint（6）

[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.