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 | InnoDB |
| connectqueuecall | NULL |
| ibobtransfer | InnoDB |
| latestuserstat | NULL |
| live_call | NULL |
| missedcalldial | InnoDB |
| missedcalldialtime | InnoDB |
| obcalldetails | InnoDB |
| queue_log | InnoDB |
| queue_member_table | InnoDB |
| queue_table | InnoDB |
| resagentevent | InnoDB |
| sipuser | InnoDB |
| todaycallsummary | NULL |
| todaycallsummary1 | NULL |
| vw_queuelog | NULL |
| waitqueuecall | NULL |
+——————–+——–+
17 rows in set (0.00 sec)
You can alter the table engine by runnung the below query on mysql prompt:

alter table crm.officeextension ENGINE=’InnoDB’;