Basic MySQL. XOR?

[david at thekramers.net (David Kramer)]

Tom Metro wrote:
> 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.

I have to agree that trying to do the diff in MySQL doesn't smell right.
 I think diff/grep.

It could be done in MySQL, but then again it could be done in COBOL.
That doesn't mean it's the best way to do it.




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