时间戳

首页 > 解决方案 > PYMYSQL 插入和上传最有效的方式。错误“格式字符串的参数不足”

python - PYMYSQL 插入和上传最有效的方式。错误“格式字符串的参数不足”

问题描述

插入和上传数据的最有效方法是什么？为什么不工作？我得到“ TypeError: not enough arguments for format string ” 但我检查了参数的数量，对我来说它看起来是正确的，16。

conn = pymysql.connect()

cursor=conn.cursor()


for row in df_tickets:

    
    sql = """
    INSERT INTO tickets (id,created_at,updated_at,solved_at,partner,status,channel,category, 
    subcategory,organization_name,group_name,requester_wait_time_in_minutes,number_assignees,number_groups,
    number_reopens,number_replies)
    VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)
    ON DUPLICATE KEY UPDATE id=%s, created_at=%s, updated_at=%s, solved_at=%s, partner=%s, status=%s, channel=%s,
    category=%s, subcategory=%s, organization_name=%s, group_name=%s, requester_wait_time_in_minutes=%s,
    number_assignees=%s, number_groups=%s, number_reopens=%s, number_replies=%s)"""
                   #(row['id'],row['created_at'],row['updated_at'],row['solved_at'],row['partner'],row['status'],
                    #row['channel'],row['category'], row['subcategory'],row['organization_name'],row['group_name'],
                    #row['requester_wait_time_in_minutes'],row['number_assignees'],row['number_groups'],row['number_reopens'],
                    #row['number_replies']))
                    #tuple(row))
    cursor.execute(sql, tuple(row))
    conn.commit()

标签： pythonmysqlpandaspymysql

解决方案

推荐阅读