☰
AMP AMP
AMP
0
AMP

How to check mysql storage engine for a database

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

MySQL
AMP AMP
Add a comment
a sample image
madridgenim
asked Nov 01 2017

Answer

AMP
0
AMP

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
a sample image
arunkumarak
asked Nov 01 2017
edited Oct 05 2018
Post your Answer