一、先设置执行SQL语句:
SELECT GROUP_CONCAT(CONCAT( 'ALTER TABLE ' ,TABLE_NAME ,' ENGINE=InnoDB; ') SEPARATOR '' )
FROM information_schema.TABLES AS t
WHERE TABLE_SCHEMA = '数据库' AND TABLE_TYPE = 'BASE TABLE';
把数据库改成你的数据库名字,这里假设我的数据库是database
SELECT GROUP_CONCAT(CONCAT( 'ALTER TABLE ' ,TABLE_NAME ,' ENGINE=InnoDB; ') SEPARATOR '' )
FROM information_schema.TABLES AS t
WHERE TABLE_SCHEMA = 'database' AND TABLE_TYPE = 'BASE TABLE';
二、得到一段超长的SQL,复制后执行这段SQL
三、查看当前数据库的字段存储信息
SHOW TABLE STATUS FROM database;
结果: