Python通过pymysql操作MySQL数据库

#PYthon与数据库链接
import io
import re

import pymysql.cursors
def mysqler(name):

    connect = pymysql.Connect(
        host="localhost",
        port=3306,
        user="账号",
        passwd='密码',
        db='zhuanke',
        charset='utf8',
    )
    cursor = connect.cursor()
# ------------------------------获取dataend----------------------------------------

    sql2 = "[\u4e00-\u9fa5].*[\u4e00-\u9fa5]"
    data = []
    with io.open("./dataend.html", encoding='utf8') as myfile:
        for i in myfile.readlines():
            ii=re.search(sql2,i)
            data.append(ii.group())











# ------------------------------获取dataend----------------------------------------
    for i in data:
        print(i)

        sql = "UPDATE zhuanke.`1_copy` SET region =%s WHERE universities=%s"


        data = (name,i)


        cursor.execute(sql, data)

        connect.commit()
        print('执行成功')

以上为代码，自行理解一下逐行代码