CODE EXAMPLE FOR SQL

how to check database engine in mysql

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