delete A from A left join(select id,name,time from A order by time desc limit 100) t1on A.id=t1.idwhere t1.id is null
