How to check table Engine in MySQL

How to check table Engine in MySQL With the help of below query, we can check the table engine in MySQL: SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES WHERE TABLE_SCHEMA = ‘nicesys’; Please change the db name to your DB name. You will get the output like : | TABLE_NAME | ENGINE | +——————–+——–+ | cdr | … Read more