List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:October 4 1999 12:07am
Subject:Re: ERROR 1062: Duplicate entry '1' for key 1
View as plain text  
On Sun, 1999-10-03 19:55:38 -0700, Del Dhanoa wrote:
> mysql> load data infile "/usr/local/webs/gsbeta/cons.txt" into table
> console;
> ERROR 1062: Duplicate entry '1' for key 1
> 
> 
> Now how do I get rid of this duplicate key?  I just want to load the
> table into mysql!

See chapter "7.15 LOAD DATA INFILE syntax" of the MySQL Reference
Manual.  It does explain how to deal with duplicate entries.

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=5244 5EF3 B0B1 3826  E4EC 8058 7B31 3AD7
Thread
ERROR 1062: Duplicate entry '1' for key 1d e l   d h a n o a4 Oct
  • Re: ERROR 1062: Duplicate entry '1' for key 1Martin Ramsch4 Oct
  • Re: ERROR 1062: Duplicate entry '1' for key 1Jan Dvorak4 Oct
  • Re: ERROR 1062: Duplicate entry '1' for key 1Jan Dvorak4 Oct
  • Re: ERROR 1062: Duplicate entry '1' for key 1Tonu Samuel4 Oct
  • Re: ERROR 1062: Duplicate entry '1' for key 1Thomas Lund4 Oct
    • Re: ERROR 1062: Duplicate entry '1' for key 1Michael Widenius6 Oct
  • Re: ERROR 1062: Duplicate entry '1' for key 1Thomas Lund7 Oct
    • Re: ERROR 1062: Duplicate entry '1' for key 1Michael Widenius7 Oct
  • Re: ERROR 1062: Duplicate entry '1' for key 1Thomas Lund7 Oct