How do I find if my a table is MyISAM or Innodb [duplicate]

Question

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

Assuming that users is a table following command does not reveal if users table is MyISAM or Innodb.

desc users;  

How do I find what is the type of users table?

Answer 1

You can use SHOW TABLE STATUS to see table information.

SHOW TABLE STATUS WHERE `Name` = 'my_table'; 

Simply check the value of the Engine column in the returned dataset to know which engine the table is using.