DELETE t_trace_registerFROM t_trace_register, ( SELECT min(id) AS id, user_id FROM t_trace_register GROUP BY user_id HAVING count(*) > 0 ) AS t2WHERE t_trace_register.user_id = t2.user_idAND t_trace_register.id > t2.id复制代码
本文共 236 字，大约阅读时间需要 1 分钟。
DELETE t_trace_registerFROM t_trace_register, ( SELECT min(id) AS id, user_id FROM t_trace_register GROUP BY user_id HAVING count(*) > 0 ) AS t2WHERE t_trace_register.user_id = t2.user_idAND t_trace_register.id > t2.id复制代码
转载地址：http://molol.baihongyu.com/