python连接mysql

import pymysql

conn = pymysql.connect(host="localhost", port=3306, user="admin", passwd="password1", db="avi_iot", charset="utf8")
cur = conn.cursor()
sql = "select id,v_mail from a_mail"
cur.execute(sql)
results = cur.fetchall()
for value1 in results:
    print(value1[0].center(10), value1[1].replace(‘@avertronics.com‘, ‘‘).split(","))
conn.close()