USE `xxdb`; SELECT CONCAT( ‘ALTER TABLE ‘ ,TABLE_NAME ,‘ ENGINE=MyISAM; ‘) as `sql-commands-for-convert-engine` FROM information_schema.TABLES AS t WHERE TABLE_SCHEMA = ‘xijishopdb‘ AND TABLE_TYPE = ‘BASE TABLE‘; show table status from xxdb
mysql 批量更换数据库表引擎 InnoDB 到 myISAM
原文：http://www.cnblogs.com/Jscriptman/p/mysql-commands-for-convert-engine.html