批量修改
数据库表的存储引擎类型的脚本
如下：
Java代码
tableList=`
mysql football_log -e "show tables"`
for tableName in ${tableList[*]}
do
case ${tableName} in Tables_in_football_log)
echo "ignore Database:"${tableName} ;;
*)
echo "日志数据库:"${tableName}
mysql football_log -e "alter table "${tableName}" engine=innodb;"
;;
esac
done
~