Mysql 去除 重复项

/* 建表 */

DROP TABLE IF EXISTS `test`;CREATE TABLE IF NOT EXISTS `test`(  `id` INT(1) NOT NULL AUTO_INCREMENT,  `name` VARCHAR(20) NOT NULL,  `add` VARCHAR(20) NOT NULL,  PRIMARY KEY(`id`))ENGINE=INNODB;

/* 插入测试数据 */
INSERT INTO `test`(`name`,`add`) VALUES('abc',"123"),('abc',"123"),('abc',"321"),('abc',"123"),('xzy',"123"),('xzy',"456"),('xzy',"456"),('xzy',"456"),('xzy',"789"),('xzy',"987"),('xzy',"789"),('ijk',"147"),('ijk',"147"),('ijk',"852"),('opq',"852"),('opq',"963"),('opq',"741"),('tpk',"741"),('tpk',"963"),('tpk',"963"),('qq',"546"),('qq',"546"),('once',"546");

/×删除重复数据方法 ×/
DELETE  `test`  FROM test  ,(  SELECT DISTINCT MIN(`id`) AS `id`,`name`,`add`  FROM `test`  GROUP BY `name`,`add`  HAVING COUNT(1) > 1) AS `test2`
WHERE `test`.`name` = `test2`.`name`  AND `test`.`add` = `test2`.`add`  AND `test`.`id` <> `test2`.`id`;

感觉这个比较靠谱