python脚本名_python脚本改库名

#!/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))