mysql 删除日志表重复数据
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 ...
转载
2019-01-24 11:36:56 ·
145 阅读 ·
0 评论