On Thursday 08 July 2004 02:35 pm, Chip Wiegand said something like: > I was sent an excel file from a remote office, and need to put the data > into a mysql database to be displayed on our web site. I removed a few > lines of fluff from the excel file and saved it as .csv (using .csv > (ms-dos)). When I try to import the file it gives me a duplicate entry for > key 1 error. I have looked through the file and the duplicate item it is > pointing to does not exist in the file. Here is the error: > > mysql> load data infile '/usr/home/autopilots/whs4.csv' > -> into table refurbs > -> fields terminated by ',' > -> optionally enclosed by '"' > -> lines terminated by '\n'; > ERROR 1062: Duplicate entry '2147483647' for key 1
That sounds like you have a number that is too large for the field, and MySQL is rolling it over. What is the type of your key? Int? Big int? And what is in that field in the Excel file? What kind of numbers? j----- k----- -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
