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

[Tonu Samuel]

> > 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!
> 
> Are you sure you have also the ID field in your data file?
> If not so, you may have to use the FIELDS clause of LOAD DATA INFILE.

  ...or use IGNORE keyword.

-- 
+----------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___                           |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Tõnu Samuel           |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     tonu@stripped        |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Tallinn, Estonia      |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                       |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                      |
|             /*/             \*\                Developers Team |
+----------------------------------------------------------------+