1 2 3 4 5 6 7 |
SELECT CONCAT( table_name, ' ', ENGINE ) FROM information_schema.TABLES WHERE table_schema = "数据库名称" AND ENGINE = "MyISAM"; |
1 2 3 4 5 6 7 |
SELECT CONCAT( 'ALTER TABLE ', table_name, ' ENGINE=InnoDB;' ) FROM information_schema.TABLES WHERE table_schema = "数据库名称" AND ENGINE = "MyISAM"; |
1 2 3 4 |
ALTER TABLE s_resource ENGINE = INNODB; ALTER TABLE s_resource_role ENGINE = INNODB; ALTER TABLE s_role ENGINE = INNODB; ALTER TABLE s_user ENGINE = INNODB; |
暂无评论