mysql how tell if using innoDB

select TABLE_SCHEMA, TABLE_NAME, ENGINE from information_schema.TABLES where ENGINE NOT IN ('MyISAM','MEMORY');

ALTER TABLE foo ENGINE='INNODB'; [alters a table ]