News & Blog

MySQL Table Not Auto Incrementing Past 127

April 12th, 2010 - Posted by Steve Marks to MySQL, Web Development.
When inserting records into a MySQL table that contains an auto-incrementing field you might at some point start receiving the following error: “Duplicate entry ‘127’ for key 1” If this is the case it means the datatype of the field in question is set as ‘tiny...