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:
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?