From: Ananda Kumar Date: June 15 2012 6:06am Subject: Re: console input List-Archive: http://lists.mysql.com/mysql/227668 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=20cf305499cb261ec704c27c9e8e --20cf305499cb261ec704c27c9e8e Content-Type: text/plain; charset=ISO-8859-1 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 < kkeller@stripped> wrote: > On 2012-06-14, Gary Aitken 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. > > --keith > > > -- > kkeller@stripped > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > > --20cf305499cb261ec704c27c9e8e--