Tabla con duplicados por email:
PARA UPDATE
update USUARIOS
inner join (
select max(id) as lastId, email
from USUARIOS
group by email
having count(*) > 1) duplic on duplic.email = USUARIOS.email
SET log= 0
where USUARIOS.id < duplic.lastId
PARA DELETE:
delete from USUARIOS
where id not in (
select max(id)
from USUARIOS
group by email)
Tabla con duplicados por email:
PARA UPDATE
update USUARIOS
inner join (
select max(id) as lastId, email
from USUARIOS
group by email
having count(*) > 1) duplic on duplic.email = USUARIOS.email
SET log= 0
where USUARIOS.id < duplic.lastId PARA DELETE: delete from USUARIOS where id not in ( select max(id) from USUARIOS group by email)