"Joshua J. Kugler" <[EMAIL PROTECTED]> wrote on 07/08/2004 04:24:41 PM:
> 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? Thanks for the tip. I'm a bit out of practice, I forgot to specify the column names - so field two was getting imported into the field 1 id column. Regards, Chip > 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] > >