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;

 

评论

1 楼 wangfeiwoyun 2011-03-10  

没看明白，什么意思？