Link to home
Start Free TrialLog in
Avatar of aguilera007
aguilera007

asked on

how to set a auto_increment to a desired value?

I have a table where one colum is uid, its a int not null auto_increment column , and it´s the primary key for that table, currently the highest value is 5284, but when I try to insert the next value, I get a huge number (2147483647) , not 5285, even phpMyAdmin in the propoerties of the table says "Next Autoindex 2,147,483,647" I´ve tried recreating the table and inserting the values again, and I still get that huge value when I try to insert a new one.

I´ve loooked in mySQL documentation on how to set a specific value in the next auto_increment value, but so far I´ve found nothing. Any clues?
ASKER CERTIFIED SOLUTION
Avatar of kelfink
kelfink

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of andriv
andriv

What are the properties you set for that field.
Avatar of aguilera007

ASKER

Great help :D