Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Basic MySQL. XOR?

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.

BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!

Boston Linux & Unix /