oneself oneself - 4 months ago 18
SQL Question

How can I check MySQL engine type for a specific table?

My MySQL database contains several tables using different storage engines
(specifically myisam and innodb). How can I find out which tables are
using which engine?

Answer

SHOW TABLE STATUS WHERE Name = 'xxx'

This will give you (among other things) an Engine column, which is what you want.