使用mysql变量。
例如，如果您有：

create table services (
  name varchar(10),
  id int
);

insert into services (name, id) values ('A', 1);
insert into services (name, id) values ('D', 2);
insert into services (name, id) values ('F', 3);
insert into services (name, id) values ('L', 4);
insert into services (name, id) values ('M', 5);

然后插入新行 B :

insert into services (name, id) values ('B', null);

然后，可以使用变量更新ids：

set @newid = 0;
update services set id = (@newid := @newid + 1)
order by name;

结果：

name        id           
----------  --
A           1            
B           2            
D           3            
F           4            
L           5            
M           6