Python连接MySQL数据库更新数据

-- 建表语句
CREATE TABLE stock_info (
  `name` varchar(255) null,
  `update_date` DATE null,
)

import mysql.connector

# MySQL数据库连接参数
config = {
    'user': '',
    'password': '',
    'host': '',
    'database': ''
}

try:
    # 连接到MySQL数据库
    cnx = mysql.connector.connect(**config)
    # 创建cursor对象
    cursor = cnx.cursor()
    # 删除库里所有数据
    delete_query = "DELETE FROM table_name"
    # 执行SQL命令
    cursor.execute(delete_query)
    # 更新数据的SQL命令
    sql_update = """
        INSERT INTO code (
            ts_code,
            symbol,
            name,
            area,
            industry,
            fullname,
            enname,
            cnspell,
            market,
            exchange,
            curr_type,
            list_status,
            list_date,
            delist_date,
            is_hs,
            act_name,
            act_ent_type,
            code)
        values (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
    """
    # 要更新的数据列表
    code_list = list()
    # 执行更新
    # cursor.execute(sql_update, new_data)
    for k in code_list:
        new_data = (
            k['ts_code'],
            k['symbol'],
            k['name'],
            k['area'],
            k['industry'],
            k['fullname'],
            k['enname'],
            k['cnspell'],
            k['market'],
            k['exchange'],
            k['curr_type'],
            k['list_status'],
            k['list_date'],
            k['delist_date'],
            k['is_hs'],
            k['act_name'],
            k['act_ent_type'],
            k['code']
        )
        cursor.execute(sql_update, new_data)
    # 提交更改
    cnx.commit()
    # 提交更改并关闭连接
    cnx.commit()
    # 关闭cursor和cnx
    cursor.close()
    cnx.close()
    print('数据更新成功')
except mysql.connector.Error as err:
    print(err)