Basic MySQL. XOR?

[sethg at ropine.com (Seth Gordon)]

This page from the MySQL documentation describes how to load data from a 
file into a table:

http://mysql.org/doc/refman/5.0/en/load-data.html

I don't have time to research the exact SQL to use, but it looks like 
your general strategy should be:

(1) Create two tables, t1 and t2, with a schema matching the input files.

(2) Load one file into t1 and the other file into t2.

(3) Create a third table, t3, containing all the rows that exist in t1 
and t2 (i.e., an inner join between t1 and t2)

(4) Delete all the rows from t1 and t2 that are in t3.

(5) Select the union of all rows from t1 and t2.

(This would be easier in PostgreSQL, since PostgreSQL allows UNION, 
INTERSECT and EXCEPT clauses in its SELECT statements, while MySQL, as 
far as I can tell from casually reading the documentation, only has 
UNION.  So if you have access to a PostgreSQL database for this task, 
use it.)

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