I have a custom module that I need to change the ID from Guid to auto increment (reason is I am syncing to a MDB file which wont accept the Guid). I done this in phpmyadmin. All works fine and I can export and import in mdb. But for some reason it seems to switch back to giud and import fails. In pic you can see first 3 are correct then it changes to 961??? and then Guid, Steps taken in phpmyadmn - I clicked on Column, ID changed CHAR to INT,Clicked A_I and set options to start from 100. I dont know why it started from 2735 but it was working until it changed back to guid.
Personally, I wouldn’t be messing with the GUID’s in the database. That just sounds like trouble.
Why not use an auto-incrementing field? This plugin seems like it would fit the bill: https://www.sugaroutfitters.com/addons/cm-sugar-sequencing-addon