我的表结构:
CREATE TABLE `userimageview` (
`user_id` int(11) unsigned NOT NULL,
`image_id` int(11) unsigned NOT NULL,
`thumbnail_view` int(10) unsigned NOT NULL,
`fullsize_view` int(10) unsigned NOT NULL,
`point` int(10) unsigned NOT NULL,
KEY `everything` (`user_id`,`image_id`,`thumbnail_view`,`fullsize_view`,`point`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
我将要添加的索引是:
ALTER TABLE `userimageview` ADD UNIQUE `user_image` (`user_id` , `image_id`)
结果:
#1062 - Duplicate entry '1-11' for key 'user_image'
我该如何添加UNIQUE
索引?
SELECT * FROM userimageview WHERE user_id = 1 AND image_id = 11
- Michael BerkowskiSELECT user_id, image_id, COUNT(*) AS dupes FROM userimageview GROUP BY user_id, image_id HAVING dupes > 1 ORDER BY dupes DESC
- Michael Berkowski