DELETE zzz_statis_20190114_copy
FROM
zzz_statis_20190114_copy,
(
SELECT min(id) as id, openid
FROM
zzz_statis_20190114_copy
GROUP BY openid
) t2
where
zzz_statis_20190114_copy.openid = t2.openid
and zzz_statis_20190114_copy.id > t2.id
DELETE zzz_statis_20190114_copy
FROM
zzz_statis_20190114_copy,
(
SELECT min(id) as id, openid
FROM
zzz_statis_20190114_copy
GROUP BY openid
) t2
where
zzz_statis_20190114_copy.openid = t2.openid
and zzz_statis_20190114_copy.id > t2.id