error on record 255 ??

[Anon]

I am having problems adding more that 255 record to my MySQL database, it is giving the folloing error:

Duplicate entry '255' for key 1

I have a field called ID which is set to:
ID tinyint(3) unsigned NOT NULL auto_increment

Any ideas??

Thanks very much 🙂

[slug58]

check out this page:

http://www.mysql.com/doc/C/o/Column_types.html

you will find that the maximum value you can have for the "tinyint" datatype is "255".

you'll basically have to change the datatype for the column.

good luck