比如这个怎么改alter table `pim_department` add ( `ownerufid2` varchar(32) DEFAULT NULL COMMENT '所有者id',
`deptDesc2` varchar(1024) DEFAULT NULL COMMENT '部门描述',
`deptLevel2` varchar(2) DEFAULT NULL COMMENT '部门等级'
) after `orgType`;
`deptDesc2` varchar(1024) DEFAULT NULL COMMENT '部门描述',
`deptLevel2` varchar(2) DEFAULT NULL COMMENT '部门等级'
) after `orgType`;
alter_specification [, alter_specification] ...alter_specification:
table_options
| ADD [COLUMN] col_name column_definition
[FIRST | AFTER col_name ]
| ADD [COLUMN] (col_name column_definition,...)
| ADD {INDEX|KEY} [index_name]
[index_type] (index_col_name,...) [index_option] ...
....
很显然从语法上看,要么 ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name ]
要么,ADD [COLUMN] (col_name column_definition,...)加多个列的时候,无法 [FIRST | AFTER col_name ]
现在的问题是如何在某列后增加多列,难道跟chm说得一样,mysql没有这个功能吗?
alter table `pim_department` add `deptDesc2` varchar(1024) DEFAULT NULL COMMENT '部门描述' after `orgType`;
alter table `pim_department` add `ownerufid2` varchar(32) DEFAULT NULL COMMENT '所有者id' after `orgType`;
add `deptDesc2` varchar(1024) DEFAULT NULL COMMENT '部门描述' after `orgType`,
add `ownerufid2` varchar(32) DEFAULT NULL COMMENT '所有者id' after `orgType`;