用Mysql时,指定一列名为id的列为auto_increment自增,但是再我删除一行后,
auto_increment列的序号不是连续的,有什么办法在删除一行后自动调整序号为连续的呢
?
eg:
create table user(
id int auto_increment,
name varchar(20)
);
insert into user values(null,'wang');
insert into user values(null,'li');
insert into user values(null,'zhang');
insert into user values(null,'sun');然后我执行删除语句:
delete from user where id=3;select * from user;查询后
显示:
1,wang
2,li
4,sun我想让它显示如下怎么办:
1,wang
2,li
3,sun
auto_increment列的序号不是连续的,有什么办法在删除一行后自动调整序号为连续的呢
?
eg:
create table user(
id int auto_increment,
name varchar(20)
);
insert into user values(null,'wang');
insert into user values(null,'li');
insert into user values(null,'zhang');
insert into user values(null,'sun');然后我执行删除语句:
delete from user where id=3;select * from user;查询后
显示:
1,wang
2,li
4,sun我想让它显示如下怎么办:
1,wang
2,li
3,sun
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货