from mydb import MyDB
from pprint import pprint
src_host = '127.0.0.1'
src_user = '******'
src_pwd = 'JING$%^789jing'
src_port = 3306
src_db = 'jmedia_ali'
try:
suffix = {}
db = MyDB(src_host, src_user, src_pwd, src_port, src_db)
sql = "select user_email from wp_users"
data = db.query(sql)
for one_row in data:
one = one_row[0]
s = one.split('@')[-1]
c = suffix.get(s, 0)
suffix[s] = c + 1
pprint(sorted(suffix.items(), key=lambda d: d[1]))
finally:
db.close()
from mydb import MyDB # 实例化数据库对象 database = MyDB(h='localhost', u='root', p='123123', db='demo1') # 插入数据 sql = 'insert into user(id,name) values(30,"祎")' print(database.change(sql)) # 定义sql语句 sql = 'select * from user' print(database.query(sql))
