自己写的导出重建索引SQL的脚本

gu14

dbschema -d database -t tablename -ss|awk '{if(/index/){printf $0" ";next;next} else{print $0}}'|grep create|grep index|sed -e 's/index/index!/g'|sed -e 's/on/!on/g'|awk -F "!" '{print "drop index "$2";;\n"$0}'

gu14

if [ 2 != $# ]
then
   echo "use: $0 DBNAME TABLE"
   exit 1
fi
#dbschema -d $1 -t $2
dbschema -d $1 -t $2 -ss|grep -v "{ TABLE"|awk '{if(/index/){printf $0" ";next;next} else print $0}}'|grep create|grep index|sed -e 's/index/index!/g'|sed -e 's/on/!on/g'|awk -F "!" '{print "drop index "$2";\n"$0}'|sed -e 's/!//g'

dintan

我看了一下 代碼 ，好像是顯示index指令 并沒有執行吧:wink: