Hi! i have a table called Estados and row called EstadoID (int), Description (varchar)
it has 3 records loaded. Now i want to make it auto_increment (EstadoID) because it wasn´t but i receive the error duplicate entry key. How can i make it auto_increment without the need to delete records or updating them (because they are foreigns keys). The problem it´s that i forgot to tell mysql that EstadoID was auto_increment
Thanks in advance. Guillermo.