在指定列后添加一列
ALTER TABLE PMInfo add department INT(4) after pmNameAbb
创建表
创建时不是联合索引,而是唯一索引(player_id),更改为联合索引
CREATE TABLE `willow_player` (
`id` bigint(11) NOT NULL AUTO_INCREMENT,
`player_id` bigint(16) NOT NULL DEFAULT '0' unique,
`award_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '类型' ,
`num` int(11) NOT NULL DEFAULT '0',
`repeat_num` smallint(11) NOT NULL DEFAULT '0' COMMENT '重复轮数',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8mb4;
### 创建时 就建立联合索引
CREATE TABLE `willow_player` (
`id` bigint(11) NOT NULL AUTO_INCREMENT,
`player_id` bigint(16) NOT NULL DEFAULT '0',
`num` int(11) NOT NULL DEFAULT '0',
`award_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '类型',