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.
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.