strange NT/MySQL problem

[Anon]

I have a problem with inserting info into a MySQL database. I create the DB and use a dump file to create tables and insert info into these tables. It works fine until it hits the field 127 at which point it says that there is already a record 127 in the table. If there are fewer than 127 records in the table it works fine, if more then it stops there with an error. If needed I can paste the file in.

[Anon]

Sure you don't have a primary key that is a tinyint?

[Anon]

You are correct I do, I assume to fix the problem I change tinyint to int?

[Anon]

You assume correctly. You should check the mysql.com/doc manuals to see what the exac ranges are