how to do persistent database connection in wordpress

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

Published by

Purab

I am Purab from India, Software development is my profession and teaching is my passion. Programmers blog dedicated to the JAVA, Python, PHP, DevOps and Opensource Frameworks. Purab's Github Repo Youtube Chanel Video Tutorials Connect to on LinkedIn

Leave a Reply

Your email address will not be published.