改数据库表类型

SELECT  CONCAT('ALTER TABLE `ycy`.`', table_name, '` ENGINE=InnoDB;') AS sql_statements
FROM    information_schema.tables AS tb
WHERE   table_schema = 'ycy'
AND     `ENGINE` = 'InnoDB'
AND     `TABLE_TYPE` = 'BASE TABLE'
AND     `TABLE_NAME` LIKE 'oc_b2b_%'

ORDER BY table_name ASC;

//ycy为数据库名称

//table_name数据库表名称

//oc_b2b_这个是模糊查询表前缀

//查询出来的是单个的更改表类型的语句如ALTER TABLE `ycy`.`oc_b2b_xxxx` ENGINE=InnoDB;

复制出来然后就可以批量更改数据库表类型了