苹果CMS MACCMS 数据表MYISAM转换为INNODB

使用PHPMYADMIN转换

SELECT 
    CONCAT('ALTER TABLE ', table_name, ' ENGINE=InnoDB;') AS alter_engine,
    CONCAT('ALTER TABLE ', table_name, ' CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;') AS alter_charset
FROM 
    information_schema.tables 
WHERE 
    table_schema = 'maccms_data' 
    AND engine = 'MyISAM';

这样就会生成转换语句

然后新窗口执行即可

转换后 可以有效提高SQL查询速度 降低系统负载 提高网站加载速度