drop table if exists test_auto_inc;
create table test_auto_inc(
       uid int auto_increment primary key,
       name varchar(50)
       );

-- use the feature

insert into test_auto_inc(name) values ('Alice');

-- show the results
select * from test_auto_inc;

-- show the table
show create table test_auto_inc;

-- ignore the feature
insert into test_auto_inc(uid,name) values (7, 'Bob');

-- show the results
select * from test_auto_inc;

-- show the table
show create table test_auto_inc;

-- what happens now?
insert into test_auto_inc(name) values ('Cathy');

-- show the results
select * from test_auto_inc;

-- show the table
show create table test_auto_inc;