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.
Autoincrement step
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.