#1062 - Duplicate entry '127' for key 1

[travelkind]

I am trying to upload some a csv file to the "raw data" table in mysql and I am getting the following error:

 

Error

SQL query:

INSERT INTO `rawdata`

VALUES (

'128', 'CI', 'TA', 'TA', 'TA', 'FL', 'P UL LS DIESEL', 'U', '12/28/2009', '18:00', '2.142', '0.037'

)

MySQL said: 

#1062 - Duplicate entry '127' for key 1

 

I am using Server version: 5.0.67.d7 of mysql.  I have tried the import a few different times (with different data) and the import seems to only import 127 rows of data.

Can anyone please help me with this?

Thanks

[fenway]

That's because you're using a signed smallint as you're primary key -- big mistake.  Try INT UNSIGNED instead.

[travelkind]

Fenway,

Thank you that solved my problem!