List the amount of data is very big, 200 million data, what do you want to be similar to the Oracle minus operation,

CodePudding user response:

Mysql does not support this, but there are other ways to achieve,
1, the exists or not exists
2, by jion

But like you so much data, the cost of these two approaches are quite big,

CodePudding user response:

Export to TXT do contrast with the join

CodePudding user response:

Export files fastest diff

CodePudding user response:

Mysql to own a checksum command, but make sure you check the two tables did not write, or do you use percona checksum tool, can compare two table data