MySQL and Python execution() only takes 3 arguments, 4 given

Question

I've searched around but it looks like most people with a similar question have two strings on one SQL variable, whereas I have two different arguments.

My code:

xpcounter = ("UPDATE CharactersDB SET Exp=%s WHERE %s", xp, name) #where is name variable
cur.execute(*xpcounter)

I have also tried:

xpcounter = ("UPDATE CharactersDB SET Exp=%s WHERE %s") #where is name variable
cur.execute(xpcounter, xp, name)

both times I get a

TypeError: execute() takes at most 3 arguments (4 given)

What am I doing wrong?

Thanks!

EDIT: As per monoid's suggestion, my code now looks like:

xpcounter = ("UPDATE CharactersDB SET Exp=%s WHERE %s", (xp, name,)) cur.execute(*xpcounter)

Now I get a

Truncated incorrect INTEGER value: 'testname'

when I run it.

EDIT: Turns out my database is updating correctly, just a warning, not an error.

monoid · Accepted Answer · 2013-07-06 16:59:58Z

4

Pass additional arguments in a tuple:

xpcounter = "UPDATE CharactersDB SET Exp=%s WHERE %s"
cur.execute(xpcounter, (xp, name,))

answered Jul 6, 2013 at 16:59

monoid

1,67111 silver badges16 bronze badges

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

3 Comments

mathieu Over a year ago

Awesome, thank you so much! EDIT: Well, now it gives a "Truncated incorrect INTEGER value:" when I enter a name. I assume (I'm still very new to coding) that it's trying to convert a string to an integer?

mata Over a year ago

@Mathieu - that's a different problem - see here

mathieu Over a year ago

thanks, I checked it and it is indeed updating properly. Thanks again!

Collectives™ on Stack Overflow

MySQL and Python execution() only takes 3 arguments, 4 given

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related