ALTER TABLE cms_member ADD `director_add_time` INT (11) UNSIGNED DEFAULT '0' COMMENT '升级为主任的时间', `manager_add_time` INT (11) UNSIGNED DEFAULT '0' COMMENT '升级为经理的时间', `president_add_time` INT (10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '晋升总裁的时间', `trustee_add_time` INT (10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '晋升董事的时间', `honorary_trustees_add_time` INT (10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '晋升荣誉董事的时间'
添加多个sql,这样运行竟然报错,好吧。
解决办法:
加个括号就好了
ALTER TABLE cms_member ADD ( `director_add_time` INT (11) UNSIGNED DEFAULT '0' COMMENT '升级为主任的时间', `manager_add_time` INT (11) UNSIGNED DEFAULT '0' COMMENT '升级为经理的时间', `president_add_time` INT (10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '晋升总裁的时间', `trustee_add_time` INT (10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '晋升董事的时间', `honorary_trustees_add_time` INT (10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '晋升荣誉董事的时间' )