table comparison

source 1146: Table 'rtg2t_test.race1' doesn't exist
1146: Table 'rtg2t_test.race1' doesn't exist


This program compares the race table with 11000 rows versus a test race table with 33 rows. Three fields were intentionally changed.The program finds the column names in the table, then finds the unique keys for the shorter table and compares the matching rows column by column. It also detects missing rows. I have provided some debugging info so you can see what is happening.

columns found =
1146: Table 'rtg2t_test.race1' doesn't exist
debug ==============
Array
(
)


========