I have a client where their next auto-increment number just jumped from 2300 to ********** for reasons not understood. They want it set back.
Options such as dropping the primary key and rebuilding the index is NOT possible -- this is a relational table thing. So, is there a way (programmatically) to set the next number in an auto-increment?
Something like:
alter table abc auto_increment = 2301;
Any ideas of why this happened?