Mysql tutorial, How to find Mysql database engine type. You need to use this command for checking the engine type. command for checking engine type.
How to find Mysql database 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:
http://dev.mysql.com/doc/refman/4.1/en/show-table-status.html
