很久以前用的了,凭记录写的,就简单测试了一下
原理是把需要的数据插到临时表中,把原表清空,再把数据迁回原表,删除临时表
create table temp as ( select * from babydata where id in(select min(id) from babydata group by tbid) )
truncate table babydata;
insert into babydata (select * from temp);
drop table temp;