mysql重置主键

set @r:=0;
update settle_content set id=(@r:=@r+1);