Find tables which are empty in database.
Find tables which are empty in database use the following query
SELECT `TABLE_NAME` FROM `TABLES` where `TABLE_SCHEMA` = '<your db schema name>' and `TABLE_ROWS` = 0 or `TABLE_ROWS` is null;
Find tables which have MyISAM engine in database use the following query.
SELECT `TABLE_NAME`,`ENGINE` FROM `TABLES` where `TABLE_SCHEMA` = '<your db schema name>' and `ENGINE` = 'MyISAM'
SELECT `TABLE_NAME` FROM `TABLES` where `TABLE_SCHEMA` = '<your db schema name>' and `TABLE_ROWS` = 0 or `TABLE_ROWS` is null;
Find tables which have MyISAM engine in database use the following query.
SELECT `TABLE_NAME`,`ENGINE` FROM `TABLES` where `TABLE_SCHEMA` = '<your db schema name>' and `ENGINE` = 'MyISAM'
