DELETE `table` AS `a` FROM `table` AS `a`,
(SELECT `title`,min(`id`) `vid` FROM `table` GROUP BY `title` HAVING COUNT(`title`) > 1)AS `b`
WHERE `a`.`title` = `b`.`title` AND `a`.`id` > `b`.`vid`

以上SQL经测试，效率最好。