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

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.