mysql - How do I find if my a table is MyISAM or Innodb

Question

(This question already has answers here): question from:https://stackoverflow.com/questions/3681790/how-do-i-find-if-my-a-table-is-myisam-or-innodb

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.