当前有表student,字段有id,name,想增加sex,sql语句为:
ALTER TABLE `student` ADD COLUMN `sex` tinyint(2) NOT NULL DEFAULT 0 COMMENT '性别,默认为男,其中0-男,1-女' AFTER `name`;
当前有表student,字段有id,name,想增加sex,sql语句为:
ALTER TABLE `student` ADD COLUMN `sex` tinyint(2) NOT NULL DEFAULT 0 COMMENT '性别,默认为男,其中0-男,1-女' AFTER `name`;