☰
✕
✕
0

How to check mysql storage engine for a database

how to check mysql storage engine for all tables in a database ....?

MySQL
Add a comment
madridgenim
asked Nov 01 2017

Answer

0

use the below methods...

mysql> SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA ='database_name';

or 

SHOW TABLE STATUS from 'db_name';
Add a comment
arunkumarak
asked Nov 01 2017
edited Oct 05 2018
Post your Answer