Get storage engine in MySql

Question

Hi,
how do i get the storage engine used by a specific database in MySql?

Thanks

Answer 1

SHOW CREATE TABLE table_name

will work for a given table.

Answer 2

or by querying information_schema:

SELECT engine 
  FROM information_schema.tables 
 WHERE table_schema = 'test' 
   AND table_name = 'q';

+--------+
| engine |
+--------+
| MyISAM |
+--------+
1 row in set (0.01 sec)