Does anyone know of an easy way to do a table comparison between 2 mysql tables? The tables have identical schemas. By comparison I mean, say table 1 row 2 column 6 has a different value that table 2 row 2 column 6, and so on.

pg_comparator seems to do this, but the sql breaks on mysql.

Before I sit down and write my own tool, or try to modify pg_comparator, I just thought I'd ask. I have a feeling that this task could be done with a single well written query, but my sql skills aren't up to that yet. Thanks in advance for your replies.