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`;

感覺這個比較靠譜