mySQL select differences between two tables in different databases mySQL select differences between two tables in different databases sql sql

mySQL select differences between two tables in different databases


Assuming the tables aren't very large you can run something like this:

SELECT *FROM OldDatabase.CommentTableWHERE COMMENT NOT IN    (SELECT COMMENT     FROM NewDatabase.CommentTable)