MySQL storage engine report

Replace YOURDATABASENAME with something slightly more relevant.

To get a list of all InnoDB tables:

SELECT TABLE_NAME AS name, ENGINE FROM information_schema.TABLES WHERE TABLES.table_schema = "YOURDATABASENAME" AND ENGINE = "InnoDB";

To get a list of all MyISAM tables:

SELECT TABLE_NAME AS name, ENGINE FROM information_schema.TABLES WHERE TABLES.table_schema = "YOURDATABASENAME" AND ENGINE = "MyISAM";