How to find the Mysql database engine type

You need to use this command for checking the engine type:

SHOW TABLE STATUS WHERE Name = ‘users’;

Or Use this command for checking the all table’s engine type.

SHOW TABLE STATUS;

Or You can use this command for database:

mysqlshow –status db_name;

I used following URL for creating this commands:

Source Article : http://wpapi.com/how-to-find-the-mysql-database-engine-type

http://dev.mysql.com/doc/refman/4.1/en/show-table-status.html

5 SHOW TABLE STATUS WHERE Name = 'xxx'