Error importing CSV With Python to MYSQL - TypeError: not enough arguments for format string

Question

I'm facing a problem trying to insert a CSV file with 800 records in the database. This gives me the following error: MySQLdb.ProgrammingError: not enough arguments for format string. I already checked and the exchanges and variables are correct, could you help me what would this problem be? Here is the code:

import MySQLdb
import csv
conn = MySQLdb.connect(host="127.0.0.1", user="root", password="", database="csm")

cursor = conn.cursor()
csv_data = csv.reader(open('teste2.csv'))
header = next(csv_data)

for row in csv_data:
    print(row)
    cursor.execute(
        "INSERT INTO estoque1 (release, official, order, date, product, client, sales, sales, quant) VALUES (%s, %s, %s, %s, %s ,%s ,%s ,%s ,%s)", row)

conn.commit()
cursor.close()

I'm facing this error but idk how to solve this. Anyone have some tips about this how can i solve?

Follow the image:

Facorazza · Accepted Answer · 2022-12-14 15:36:12Z

2

Because you're passing the array as an argument while the execute() function expects all the elements of the array as a single argument.

You should be able to pass the array like this:

cursor.execute(
    "INSERT INTO estoque1 (release, official, order, date, product, client, sales, sales, quant) VALUES (%s, %s, %s, %s, %s ,%s ,%s ,%s ,%s)",
    *row
)

Note the asterisk.

edited Dec 14, 2022 at 15:36

answered Dec 14, 2022 at 15:02

Facorazza

3362 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

clfaster · Accepted Answer · 2022-12-14 15:21:52Z

1

The Problem is that you only pass one parameter (the row list) to the 9 placeholders in your string. To fix that you need either convert the list to a tuple, use the "*" operator to unpack the list or pass all the values of the list individually.

Use the * operator to unpack:

row = [1, 2, 3, 4]
"%s %s %s %s" % (*row,)

Use tuple:

row = [1, 2, 3, 4]
"%s %s %s %s" % tuple(row)

Or you list all parameters extra:

row = [1, 2, 3, 4]
"%s %s %s %s" % (row[0], row[1], row[2], row[3])

edited Dec 14, 2022 at 15:21

answered Dec 14, 2022 at 15:16

clfaster

1,90422 silver badges30 bronze badges

Collectives™ on Stack Overflow

Error importing CSV With Python to MYSQL - TypeError: not enough arguments for format string

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related