How to find Mysql database engine type

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

No Comments

Add a Comment

Your email address will not be published. Required fields are marked *