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