Load Data question

[Joel Holtzman]

Hello, what is the correct syntax forignore?

I have a table with columsn already put in, and primary key has 0 as value.

When I do "load data infil 'file.txt'...

it gives a duplicate error. Documentation says to use 'ignore'. But I can't get it to 
work.

What is the *correct* syntax to load a file with columns to *overwrite* what I have in 
a table? It would make life easier as all the 'gui' software is either confusing, in 
another language, or doesn't work.

Thanks