I get this error message when i try to insert a new record into a table in my MySQL database.
"MySQL Said: Duplicate entry '127' for key 1"
The last record I entered received the Primary Key ID 127 by autoincrement. Now I cannot add another record. If I delete the record 127 I can add one record then start recieving the error again.
When inserting I am not giving each record an ID , I leave that to MySQL to do via the autoincrement. I am baffled. Any ideas?
"MySQL Said: Duplicate entry '127' for key 1"
The last record I entered received the Primary Key ID 127 by autoincrement. Now I cannot add another record. If I delete the record 127 I can add one record then start recieving the error again.
When inserting I am not giving each record an ID , I leave that to MySQL to do via the autoincrement. I am baffled. Any ideas?