On 2012-06-14, Gary Aitken <my...@dreamchaser.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 -- kkel...@wombat.san-francisco.ca.us -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql