Basic MySQL. XOR?

[blu at vl.com (Tom Metro)]

Dwight E Chadbourne wrote:
> Two people are handing me CSV files and I don't care about what they
> agree on.

If you want to see differences at the record (line) level, try:

% diff --old-line-format=%L --new-line-format=%L
--unchanged-line-format="" data1.csv data2.csv > diff.csv

diff.csv should end up with none of the lines that are identical in the
two source files, and only contain the lines that differ.

You can the load diff.csv into MySQL.

  -Tom

-- 
Tom Metro
Venture Logic, Newton, MA, USA
"Enterprise solutions through open source."
Professional Profile: http://tmetro.venturelogic.com/

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.