compare two tables in MYSQL

Anonymous — Thu, 12 May 2016 05:09:30 GMT

I have created talend program to insert data in 34 columns of a table after joining 9 tables (Lets say Table1)
Same thing done with MySQL procedure.(Lets say Table2)
Now, I have to compare the two tables (Table1 with Table2)
Both the table are expected to have same data. In both the tables I have 1,14,743 rows.
Is there any reliable free tool available for this to make sure each and every data in each and every column is same in both the tables? If there is difference, which data is different.
is there any other way to compare?
Please help me.

Re: compare two tables in MYSQL

Anonymous — Fri, 13 May 2016 07:51:10 GMT

Hi,
Do you want to compare two table with same structure and different data set?
Here is analysis feature in Talend Data Quality Product
Could you please take a look at documents about: TalendHelpCenter:Table analyses and TalendHelpCenter:Creating a match analysis?
Feel free to let us know if it is Ok with you.
Best regards
Sabrina

topic compare two tables in MYSQL in Talend Studio

compare two tables in MYSQL

Re: compare two tables in MYSQL