php 获取自增长 id,mysql 自增id feature 测试

1、建表插入数据

查看表结构

插入数据

insert into tb_staff values(null,'hr','li2',24);

insert into tb_staff values(null,'tech','li3',35);

insert into tb_staff values(null,'tech','li4',35);

insert into tb_staff values(null,'tech','li5',40);

insert into tb_staff values(null,'hr','li6',26);

查看数据自增id，根据顺序自动增加

2、删除单条记录再插入

删除数据后再插入新数据 ，自增id会继续增加，不会复用原id，除非重置

删除id为7的一条数据

delete from tb_staff where id = 7 ;

select * from tb_staff where id = 7;

插入新的数据，查看自增id

insert into tb_staff values(null,'hr','li6',26);

3、重置自增id，再插入数据

重置自增id,数据量大重置会非常慢

alter table tb_staff auto_increment =1;

再插入数据，查看自增id为顺序自增

insert into tb_staff values(null,'hr','li6',26);

清空表语句

truncate table tb_name;