pymysql快速执行mysql语句

# 执行SQL-mysql
import pymysql

# 执行 查询
def select_mysql(sql: str):
    conn = pymysql.connect(host="localhost",
                           port=3306,
                           user="root",
                           password="123456",
                           db="authcenter",
                           charset="utf8")
    cur = conn.cursor()
    cur.execute(sql)
    data = cur.fetchall()
    conn.close()
    return data

# 执行 增删改
def add_del_update_mysql(sql: str):
    conn = pymysql.connect(host="localhost",
                           port=3306,
                           user="root",
                           password="123456",
                           db="authcenter",
                           charset="utf8")
    cur = conn.cursor()
    cur.execute(sql)
    conn.commit()
    conn.close()


if __name__ == '__main__':
    # 查询-学校字典表
    sql: str = 'select * from school_shaoxing limit 0,10'
    data = select_mysql(sql)
    for i in data:
        # 查询-组织字典表
        sql001: str = f'select * from base_system_org where name = "诸暨市{i[1]}"'
        data001 = select_mysql(sql001)
        if len(data001) == 1:
            j = list(i)
            j[3] = data001[0][0]
            j[4] = data001[0][3]
            sql002: str = f'update school_shaoxing set zhuomei_org_id="{j[3]}",zhuomei_org_code="{j[4]}" where id="{j[0]}"'
            mysql = add_del_update_mysql(sql002)