How to remove duplicate rows from a MySQL table

remove-duplicate-rows-from-mysql-table.sql

-- For example, a members table that has duplicate emails
-- Needs unique id field to work

create temporary table tmpTable (id int);

insert  tmpTable
        (id)
select  id
from    members m
where   exists
        (
        select  *
        from    members m2
        where   m2.email = m.email
                and m2.id > m.id
        );

delete  
from    members
where   ID in (select id from tmpTable);