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.
Actually, what might make more sense is to use un*x command line tools to help. Use cut to extract only the columns of your primary key, use sort (not with -u!) to sort the rows, and use uniq -d to print out only duplicate lines. e.g. cut -f1 mytable.tab | sort | uniq -d It won't tell you which line number(s) are problematic, however; it just tells you which values for your PK are duplicated. If you need the line number use one of the other suggestions. --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