How can I check MySQL engine type for a specific database?

checkMysqlEngineType.sql

SELECT `ENGINE` FROM `information_schema`.`TABLES` WHERE `TABLE_SCHEMA`='your_database_name' AND `TABLE_NAME`='your_table_name';