mysql 删除重复数据只保留一条记录

delete from order_info where id not in (select id from (select min(id) as id from order_info group by order_number) as b);