Did you try using "IGNORE" keyword while using the LOAD DATAFILE command.
This will ignore duplicate rows from getting inserted and proceed further.
On Fri, Jun 15, 2012 at 11:05 AM, Keith Keller <
> On 2012-06-14, Gary Aitken <mysql@stripped> wrote:
> > So... I wanted to read the data line at a time and use a plain INSERT
> statement. That way I could check for duplicate keys and discover where
> the duplicate records are. However, I can't find a way to read input from
> the console or a file. What am I missing? I know I could write a java or
> C++ program to do this, but it seems like overkill for what should be a
> trivial task.
> I don't know of any stock mysql program that does such a thing. You
> could write a Perl or Python program for this task; this program would
> probably be fairly short.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql