List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:June 15 2012 6:06am
Subject:Re: console input
View as plain text  
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 <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.
>
> --keith
>
>
> --
> kkeller@stripped
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>

Thread
console inputGary Aitken15 Jun
  • Re: console inputKeith Keller15 Jun
    • Re: console inputAnanda Kumar15 Jun
  • Re: console inputJohan De Meersman15 Jun
    • Re: console inputGary Aitken15 Jun
  • Re: console inputShawn Green15 Jun
  • Re: console inputKeith Keller15 Jun