Mysql
mysql 스토리지 엔진 타입 확인 쿼리
ohrohi
2016. 8. 30. 15:10
반응형
SELECT engine, support FROM information_schema.engines WHERE support='DEFAULT';
+--------+---------+
| engine | support |
+--------+---------+
| InnoDB | DEFAULT |
+--------+---------+
SELECT engine, support FROM information_schema.engines WHERE support='DEFAULT';
+--------+---------+
| engine | support |
+--------+---------+
| MyISAM | DEFAULT |
+--------+---------+
반응형