Q:

Query to check the difference of tables in two warehouses

I have two environments (production and development)
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'production';

Qty of tables in production 300
After to install a new feature in development appeared more tables
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'development';

Qty of tables in development 303
I wonder if there is a Query (no extencion like MySQLdiff ) to check what are the tables that have been added, i mean the 3 tables that are in development but not in production.  

A:

How about using LEFT JOIN to get a diff of two temporary tables, namely one with your production scheme tables and one with your development scheme tables:
SELECT table_name_development FROM
  (SELECT table_name AS table_name_development FROM information_schema.tables WHERE table_schema = 'development') AS d
LEFT JOIN
  (SELECT table_name AS table_name_production FROM information_schema.tables WHERE table_schema = 'production') AS p
ON table_name_development=table_name_production
WHERE table_name_production IS NULL;

