批量修改Mysql数据库表Innodb为MyISAN

mysql -uroot -e "SELECT concat(‘ALTER TABLE ‘, TABLE_NAME,‘ ENGINE=MYISAM;‘) FROM Information_schema.TABLES WHERE TABLE_SCHEMA = ‘jitamin2‘ AND ENGINE = ‘InnoDB‘ AND TABLE_TYPE = ‘BASE TABLE‘" 

批量修改Mysql数据库表Innodb为MyISAN

标签：mysql   pre   san   blog   innodb   修改   ash   mysql数据库   sch