Mysql Auto increment goest 10 by 10

Question

I have a MySQL table with an auto increment id declared as follows:

create table bases(
    idBase int primary key auto increment,
    nombreBase varchar(50) not null
)

When I insert two records:

insert into bases values('Base 1');
insert into bases values('Base 2');

It should go with id 1 and then 2, but it goes 1 and then 11, if I insert a third takes 21. Is there any particular reason why this is happening?

Thanks in advance!

EDIT!!!!

Solved thanks to the answer provided here

Try running SHOW VARIABLES LIKE 'auto_inc%'; If auto_increment_increment is not 1 then that could be your answer — jeff carey, Nov 04 '15 at 21:22
I solved thanks to what answered here http://stackoverflow.com/questions/206751/mysql-autoincrement-column-jumps-by-10-why — Josue Martinez, Nov 04 '15 at 21:26

score 2 · Accepted Answer · edited May 23 '17 at 11:52

2

IN my search I found some things to help you on your way

Explicitly: Try running this in your db manager

SHOW VARIABLES LIKE 'auto_inc%';

edited May 23 '17 at 11:52

Community

answered Nov 04 '15 at 21:27

davejal

1 Answers1