OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: console input

From: Keith Keller (kkellerwombat.san-francisco.ca.us)
Date: Fri Jun 15 2012 - 00:35:23 CDT


On 2012-06-14, Gary Aitken <mysqldreamchaser.org> 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

--
kkellerwombat.san-francisco.ca.us

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql