mysql 批量增加字段命令_sql使用命令批量给一个表添加字段

现在假设我有一个member表，我想给这个表中添加一些新的列属性：

alter table member add member_height VARCHAR(10) NULL;

alter table member add member_professional VARCHAR(50) NULL;

alter table member add member_specialty VARCHAR(200) NULL;

alter table member add member_carinfo VARCHAR(50) NULL;

alter table member add member_isteach VARCHAR(10) NULL;

alter table member add member_bloodtype VARCHAR(10) NULL;

alter table member add member_constellation VARCHAR(30) NULL;

alter table member add member_character VARCHAR(100) NULL;

alter table member add member_married VARCHAR(10) NULL;

alter table member add member_income VARCHAR(50) NULL;

alter table member add member_postcode VARCHAR(50) NULL;

alter table member add member_msn VARCHAR(50) NULL;

alter table member add member_zhifubao VARCHAR(100) NULL;

alter table member add member_bankcard VARCHAR(100) NULL;

alter table member add member_programname VARCHAR(200) NULL;

alter table member add member_participants VARCHAR(100) NULL;

alter table member add member_person INT(10) NULL;

alter table member add member_agescope VARCHAR(50) NULL;

alter table member add member_programtime VARCHAR(50) NULL;

alter table member add member_isoriginal VARCHAR(10) NULL;

alter table member add member_award VARCHAR(500) NULL;

alter table member add member_dream VARCHAR(500) NULL;

alter table member add member_ability VARCHAR(500) NULL;

分享到：

2010-11-03 11:15

浏览 3940

分类:数据库

评论

1 楼

wangfeiwoyun

2011-03-10

没看明白，什么意思？