Monday, 26 December 2016

[Maria/MySQL] Change Table Storage Engine (테이블 엔진 변경)

1. Check table storage engine (테이블 별 엔진 확인)

SELECT TABLE_SCHEMA,TABLE_NAME,ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='[DB_NAME]';




2. Change storage engine (테이블 엔진 변경)

ALTER TABLE [TABLE_NAME] ENGINE='[STORAGE_ENGINE]';