我一般是这样操作的,呵呵!create temporary table tmp select * from your_talbe group by sjhm order by id;
truncate your_table;
insert into your-table select * from tmp order by id;
drop table tmp;
truncate your_table;
insert into your-table select * from tmp order by id;
drop table tmp;
可惜不支持