Senin, 05 Agustus 2019

How to check MySql database table engine

  Tidak ada komentar
Issue the following command on mysql console
MariaDB [(none)]> SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = 'mybilling';
+-------------------------+--------+
| TABLE_NAME              | ENGINE |
+-------------------------+--------+
| log_checkbilling        | InnoDB |
| status                  | InnoDB |
| sys_files               | MyISAM |
| sys_user_history_login  | MyISAM |
| sys_user_login_attempts | MyISAM |
| sys_user_permissions    | MyISAM |
| sys_user_profile        | MyISAM |
| sys_user_roles          | MyISAM |
| sys_user_sessions       | MyISAM |
| sys_user_temp           | MyISAM |
| sys_users               | MyISAM |
| tabref                  | InnoDB |
| tabuser                 | InnoDB |
| tabuser_old             | InnoDB |
+-------------------------+--------+
14 rows in set (0.00 sec)



Tidak ada komentar :

Posting Komentar