Find the Storage Engine of my MySQL tables

use Tablename;
select table_name, ENGINE FROM INFORMATION_SCHEMA.TABLES 
WHERE table_schema=DATABASE();