How to select the MySQL's engine name of some table by sql query?

Question

How to select the MySQL's engine name of some table. MyISAM or InnoDB. Can we do it by a simple sql query?

Duplicate: http://stackoverflow.com/questions/213543/how-can-i-check-mysql-engine-type-for-a-specific-table — AvatarKava, Sep 15 '09 at 12:30

score 1 · Accepted Answer · answered Sep 15 '09 at 12:30

1

Try

SHOW TABLE STATUS FROM db_name

answered Sep 15 '09 at 12:30

pavium

score 1 · Answer 2 · answered Oct 05 '09 at 19:36

1

You can also use the INFOMATION_SCHEMA database:

SELECT ENGINE FROM TABLES WHERE TABLE_NAME LIKE 'words';

answered Oct 05 '09 at 19:36

rutgerw

2 Answers2