mysql determine storage engine code example

Example: how to check database engine in mysql

SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = 'database';