Wednesday, 25 May 2016

 mysql how to know innodb or myisam

IN order to check whether the tables are innodb or myisam please follow below steps:

1. Login to mysql
2. Run below query
SHOW TABLE STATUS WHERE `Name` = 'my_table';
Just one note: you will see if searched table under your schema. I other case the output would be empty

Example:

No comments:

Post a Comment