Удаление дублей в таблице Mysql

Делается 4мя командами

CREATE TEMPORARY TABLE IF NOT EXISTS temp_table(`id` int(10)) ENGINE=MEMORY;

TRUNCATE TABLE temp_table;

INSERT INTO `temp_table` (SELECT MIN(id) as id FROM `table` GROUP BY `email`);

DELETE FROM `table` WHERE `id` NOT IN (SELECT `id` FROM `temp_table`);