I have a client where their next auto-increment number just jumped from 2300 to 1000000000 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?
alter table abc auto_increment = 2301;
Any ideas of why this happened?