python操作mysql中的表统计_python脚本统计 MySQL 库中表的个数

#!/usr/bin/python

import os,sys,pymysql

mysqlbase = ‘/usr/local/mysql/bin/‘

if  len(sys.argv)  == 1:

print(‘format: python + Script_name + user + password + ip‘)

elif sys.argv[1] == ‘-h‘:

print(‘format: python + Script_name + user + password + ip‘)

else:

user = sys.argv[1]

passw = sys.argv[2]

ip = sys.argv[3]

dbnam=os.popen(mysqlbase+‘mysql -h‘+ip+‘ -u‘+user+‘ -p‘+passw+‘   -h‘+ip+‘ -e "show databases"|grep -vE "mysql|Database|information_schema|performance_schema|sys"‘).read()

#    dbnam=os.popen(mysqlbase+‘mysql -h‘+ip+‘ -u‘+user+‘ -p‘+passw+‘  -S /tmp/mysql3306.sock -h‘+ip+‘ -e "show databases"|grep -vE "mysql|Database|information_schema|performance_schema|sys"‘).read()