Re: ERROR 1062: Duplicate entry '1' for key 1

[Martin Ramsch]

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