日期:2014-05-16  浏览次数:20465 次

批量修改数据库表的存储引擎类型的脚本
如下:
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
~