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
原文：http://www.cnblogs.com/haoliansheng/p/6641157.html
