SELECT TABLE_SCHEMA,TABLE_NAME,ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='[DB_NAME]';
ALTER TABLE [TABLE_NAME] ENGINE='[STORAGE_ENGINE]';