mySQL中删除unique key的语法
CREATE TABLE `good_booked` (
`auto_id` int(10) NOT NULL auto_increment,
`good_id` int(11) default NULL,
`chemist_id` int(11) default NULL,
PRIMARY KEY (`auto_id`),
UNIQUE KEY `good_id` (`good_id`,`chemist_id`),
KEY `current_state` (`current_state`),
KEY `send_time` (`send_time`)
)
`auto_id` int(10) NOT NULL auto_increment,
`good_id` int(11) default NULL,
`chemist_id` int(11) default NULL,
PRIMARY KEY (`auto_id`),
UNIQUE KEY `good_id` (`good_id`,`chemist_id`),
KEY `current_state` (`current_state`),
KEY `send_time` (`send_time`)
)
想删除某个表中某个字段的unique key：
ALTER TABLE good_booked DROP INDEX good_id;
原帖：http://wystec.blog.163.com/blog/static/29614447200910203498200/