python脚本改库名
2017-12-12 11:50 ndzj 阅读(375) 评论(0) 编辑 收藏 举报#!/usr/bin/env pythpn
import os,time
olddb = 'hln'
newdb = 'fs'
ip = '192.168.1.26'
user = 'root'
password = '123456'
os.system('mysql -h%s -u%s -p%s -e "create database If Not Exists %s Character Set UTF8"' %(ip,user,password,newdb))
table = os.popen('mysql -h%s -u%s -p%s -e "select TABLE_NAME from information_schema.TABLES where TABLE_SCHEMA=\'%s\'"''|grep -v TABLE_NAME' %(ip,user,password,olddb)).read().replace('\n',',').rstrip(',').split(',')
for tab in table:
os.system('mysql -h%s -u%s -p%s -e "rename table %s.%s to %s.%s"' %(ip,user,password,olddb,tab,newdb,tab))
time.sleep(0.5)
os.system('mysql -h%s -u%s -p%s -e "drop database %s"' %(ip,user,password,olddb))
