MySQL中删除数据后主键id重置的问题
创建数据库
create database db1;
use db1;
create table user3(
id int primary key auto_increment,
username varchar(16) not null unique ,
password varchar(16) not null,
createDatetime date
);
insert into user3 (username,password,createDatetime) values
("张伟","pass1","2019-07-11"),("王伟","pass2","2019-07-11"),
("王芳","pass3","2019-07-12")