Check mysql engine for a specific table

In MySql, there are many storage engines like MyISAM, InnoDB etc. What if you want to check the type of storage engine for a specific table as what storage engine it is using. You can check it as follows:

Run the below query:

SHOW TABLE STATUS WHERE Name='your_table_name'

The above query will give you the storage engine name with some more additional data, your table uses.

Similarly, if you want to check storage engines for all tables in your mysql database at once, then simply run this query:

SHOW TABLE STATUS

It will give you details about the storage engines for all the tables in your mysql database.