Auto_incremente

polonskyg · July 6th, 2005, 01:32 PM

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.

ChrisScott · July 6th, 2005, 01:47 PM

Hi Guillermo,

Something like this should do it...

Code:

ALTER TABLE Estados MODIFY COLUMN EstadoID INT AUTO_INCREMENT;

HTH,

Chris

polonskyg · July 7th, 2005, 08:22 AM

No.... mysql says
Duplicate entry '1' for key 1

This is the content of Estados table

Descripcion EstadoID Imagen
RESERVADO 0 98148-750098490_cartel_raulMel.jpg
Sin Estado 1 59259-685750268_notavailable.JPG
Vendida 2 90741-685750269_notavailable.JPG

ChrisScott · July 7th, 2005, 08:42 AM

You should not have a zero value in an AUTO INCREMENT column.