Autoincrement step

[expired user #9597]'s profile image [expired user #9597] posted 8 years ago in General Permalink

I am new to mysql and have setup a database that is hosted with Network Solutions. Using both HeidiSql and another management tool I find that when entering data through the management tool my primary key autoincrement ID field is incrementing by 3 each time. I can't see any setting to get the step value to be 1 as it should be. Can anyone shed some light on this? TNX.

ansgar's profile image ansgar posted 8 years ago Permalink

There is indeed a server-side variable for this. To see the current setting, just go to HeidiSQL's "Host" tab, then to the sub-tab "Variables", and find the auto_increment_increment variable. You can also doubleclick to modifiy its value. Pay attention to the scope: only the global scope will make it permanent.

Please login to leave a reply, or register at first.