I installed MySQL Workbench the other day, accessed my company's database and made myself a table to work with. So far so good. The problem is, I noticed my auto_increment is incrementing 2 by 2. For example:
ID NAME
1 Paul
3 Jack
5 Louis
7 John
...
When I do SHOW VARIABLES LIKE 'auto_inc%'
I get this:
'auto_increment_increment', '2'
'auto_increment_offset', '1'
So I tried setting auto_increment_increment
to 1 with:
SET @@auto_increment_increment=1
And after verifying again with SHOW VARIABLES LIKE 'auto_inc%'
I confirmed it "worked" with the result:
'auto_increment_increment', '1'
'auto_increment_offset', '1'
But my ID's are still being incremented in 2 by 2.
The first time I did it, it worked well and then I closed MySQL Workbench to realize that when I opened it again, auto_increment_increment
was set to 2 again. Now I'm trying to do it again, but it doesn't even seem to work anymore.
Can anyone help me with this, please?
Thanks guys.