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

SHOW TABLE STATUS WHERE Name = 'xxx'

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

To show a list of all the tables in a database and their engines, use this SQL query:

SELECT TABLE_NAME,       ENGINEFROM   information_schema.TABLESWHERE  TABLE_SCHEMA = 'dbname';

Replace dbname with your database name.

mysql innodb myisam

SHOW CREATE TABLE <tablename>;

Less parseable but more readable than SHOW TABLE STATUS.

CodeHunter