Python MySQL DB executemany does not work on one value

Question

I am trying to do a batch insert for a single value (row), I am trying to use the executemany function to do so, but it will not work it returns TypeError: not all arguments converted during string formatting. However, when I add an extra value it does work

So... It will return an error here:

entries_list=[("/helloworld"),
                ("/dfadfadsfdas")]
cursor.executemany('''INSERT INTO fb_pages(fb_page)
        VALUES (%s)''', entries_list)

But not here:

entries_list=[("/helloworld", 'test'),
                ("/dfadfadsfdas", 'rers')]
cursor.executemany('''INSERT INTO fb_pages(fb_page, page_name)
        VALUES (%s, %s)''', entries_list)

tktk · Accepted Answer · 2014-06-21 09:06:13Z

4

Writing ("/helloworld") is the same as writing "/helloworld". To create a tuple you need ("/helloworld", ).

What you're doing is actually running this:

cursor.executemany('''INSERT INTO fb_pages(fb_page)
    VALUES (%s)''', ["/helloworld","/dfadfadsfdas"])

And now the error you're receiving makes perfect sense - you're supplying two arguments with only one place holder. Defining entries_list as follows would solve the problem:

entries_list=[("/helloworld",),
            ("/dfadfadsfdas",)]

edited Jun 21, 2014 at 9:06

answered Jun 20, 2014 at 20:33

tktk

11.8k8 gold badges61 silver badges75 bronze badges

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

Comments

systemdebt · Accepted Answer · 2019-11-19 19:05:52Z

2

In addition to making tuple with an additional , at the end as pointed by Karem

entries_list=[
    ("/helloworld",),
    ("/dfadfadsfdas",)
]

You could also just pass in lists and that will sort it out for you just as good when you are using parameterized query.

    entries_list=[
      ["/helloworld"],
      ["/dfadfadsfdas"]
]

answered Nov 19, 2019 at 19:05

systemdebt

4,97116 gold badges61 silver badges146 bronze badges

Collectives™ on Stack Overflow

Python MySQL DB executemany does not work on one value

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