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

[Jan Dvorak]

That's easy:

load data infile "/usr/local/webs/gsbeta/cons.txt"
  into table console ( title, url, description, category, keywords );

-- Jan Dvorak, MathAn Praha, CZ.

d e l d h a n o a wrote:

> I do not have the id field in my data field...
>
> hmm.. that may be the problem, then what should my LOAD DATA command look
> like with that clause?
>
> - Del