Insert_id starting "1"

by default, DB indexes start at 1

create table test(id int auto_increment, name int, primary key(id));
insert into test(name) values(2);
select * from test;
id	name
1	2

but the value of an ID should be irrelevant anyway, as long as its unique.

1 Like