I am working with multiple databases which have the same structure and are on the same server. All of them are MySQL databases and I'm using MySQL Workbench (community version!) to connect to them.
I need to retrieve data from all (or some) of them and compare the results. sometimes I need to store the retrieved data from those databases in another database.
How can I manage that?