madridgenim
asked Nov 01 2017
Answer
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';
arunkumarak
asked Nov 01 2017
edited Oct 05 2018
How to check mysql storage engine for a database
how to check mysql storage engine for all tables in a database ....?