mysql 按照时间的先后顺序进行保留最新的唯一数据

也许你要的是这个，表名和列名自己替换下

delete
from tb_phone
where id in (
    select id from(
        select a.id
        from tb_phone a
        join (
            select max(id) as id, phone, count(id) as num
            from tb_phone
            group by phone
            having num > 1
        ) b 
            on a.phone = b.phone and a.id != b.id
    ) as c
)