ICMS MySQL数据表的MyISAM转换成InnoDB引擎的两种方法

ALTER TABLE `cqcms_access_log` ENGINE = INNODB;

ALTER TABLE `cqcms_apps` ENGINE = INNODB;

ALTER TABLE `cqcms_apps_store` ENGINE = INNODB;

ALTER TABLE `cqcms_article` ENGINE = INNODB;

ALTER TABLE `cqcms_article_data` ENGINE = INNODB;

ALTER TABLE `cqcms_article_meta` ENGINE = INNODB;

ALTER TABLE `cqcms_category` ENGINE = INNODB;

ALTER TABLE `cqcms_category_cdata` ENGINE = INNODB;

ALTER TABLE `cqcms_category_map` ENGINE = INNODB;

ALTER TABLE `cqcms_category_meta` ENGINE = INNODB;

ALTER TABLE `cqcms_comment` ENGINE = INNODB;

ALTER TABLE `cqcms_config` ENGINE = INNODB;

ALTER TABLE `cqcms_favorite` ENGINE = INNODB;

ALTER TABLE `cqcms_favorite_data` ENGINE = INNODB;

ALTER TABLE `cqcms_favorite_follow` ENGINE = INNODB;

ALTER TABLE `cqcms_files` ENGINE = INNODB;

ALTER TABLE `cqcms_files_map` ENGINE = INNODB;

ALTER TABLE `cqcms_forms` ENGINE = INNODB;

ALTER TABLE `cqcms_group` ENGINE = INNODB;

ALTER TABLE `cqcms_keywords` ENGINE = INNODB;

ALTER TABLE `cqcms_links` ENGINE = INNODB;

ALTER TABLE `cqcms_members` ENGINE = INNODB;

ALTER TABLE `cqcms_message` ENGINE = INNODB;

ALTER TABLE `cqcms_prop` ENGINE = INNODB;

ALTER TABLE `cqcms_prop_map` ENGINE = INNODB;

ALTER TABLE `cqcms_search_log` ENGINE = INNODB;

ALTER TABLE `cqcms_sph_counter` ENGINE = INNODB;

ALTER TABLE `cqcms_spider_error` ENGINE = INNODB;

ALTER TABLE `cqcms_spider_post` ENGINE = INNODB;

ALTER TABLE `cqcms_spider_project` ENGINE = INNODB;

ALTER TABLE `cqcms_spider_rule` ENGINE = INNODB;

ALTER TABLE `cqcms_spider_rule_20190729` ENGINE = INNODB;

ALTER TABLE `cqcms_spider_url` ENGINE = INNODB;

ALTER TABLE `cqcms_spider_url_data` ENGINE = INNODB;

ALTER TABLE `cqcms_spider_url_list` ENGINE = INNODB;

ALTER TABLE `cqcms_tag` ENGINE = INNODB;

ALTER TABLE `cqcms_tag_map` ENGINE = INNODB;

ALTER TABLE `cqcms_tag_meta` ENGINE = INNODB;

ALTER TABLE `cqcms_user` ENGINE = INNODB;

ALTER TABLE `cqcms_user_category` ENGINE = INNODB;

ALTER TABLE `cqcms_user_data` ENGINE = INNODB;

ALTER TABLE `cqcms_user_follow` ENGINE = INNODB;

ALTER TABLE `cqcms_user_openid` ENGINE = INNODB;

ALTER TABLE `cqcms_user_report` ENGINE = INNODB;

本文链接：https://www.0937.biz/post-3135.html