TypeError: not enough arguments for format string for mysqldb

Question

I am trying to push a large csv of data into a mysql database and keep getting errors so I have simplified the insert to the following. I have seen a number of similar questions on here, but I haven't been able to get those to work for me. What am I missing? It should also note that it prints fine when I try that.

import MySQLdb as mdb
con = mdb.connect(host='', port=3306, user='', passwd='', db='')


cursor = con.cursor()
cursor.executemany("INSERT INTO schema.table (Account_Number, Sales_Total) "
                       "VALUES(%s, %s)", ('Account 1', 2))

error:

TypeError: not enough arguments for format string

Possible duplicate of How can I use executemany to instert into mysql a list of dictionaries in python — Raunak Agarwal
– Raunak Agarwal, Commented Jan 12, 2016 at 5:48

taleinat · Accepted Answer · 2016-01-14 14:20:16Z

4

executemany() should be passed a sequence of tuples as the second argument (see the docs). The following should work for you:

cursor.executemany("INSERT INTO schema.table (Account_Number, Sales_Total) "
                   "VALUES(%s, %s)", [('Account 1', 2)])

Explanation for the strange error message: In your code you are passing a single tuple, which is also a sequence, so executemany() tries to format the query with just 'Account 1', and therefore complains that it doesn't have enough arguments.

Edit:

P.S. Strings are also sequences (of characters), but specifically string formatting treats them as a single value instead of as a sequence of characters. Otherwise, the original code would have created an error complaining about too many arguments instead of too few...

edited Jan 14, 2016 at 14:20

answered Jan 12, 2016 at 5:52

taleinat

8,7411 gold badge36 silver badges47 bronze badges

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

Collectives™ on Stack Overflow

TypeError: not enough arguments for format string for mysqldb

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related