Error in mysql query using python script

Question

I have wrote an instruction to fetch frequency from database using 2 id's as shown below:

cursor = db.cursor()
cursor.execute("select freq from matrix_brown where a_id in (%s) and b_id in (%s)",b_item_id,b_after_id)
b_freq=cursor.fetchone()

but i'm getting this error :

cursor.execute("select freq from matrix_brown where a_id in (%s) and b_id in (%s)",b_before_id,b_item_id)
TypeError: execute() takes at most 3 arguments (4 given)

pls help me out.. Thank you.. :)

AlG · Accepted Answer · 2011-04-01 18:38:05Z

1

If you want execute to fill in the string your calling it wrong:

cursor.execute("select freq from matrix_brown where a_id in (?) and b_id in (?)", (b_item_id,b_after_id))

answered Apr 1, 2011 at 18:38

AlG

15.3k4 gold badges43 silver badges54 bronze badges

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

1 Comment

AlG Over a year ago

Glad to help! Please accept the answer if this solved the problem for you. :)

Clodoaldo Neto · Accepted Answer · 2011-04-01 18:41:06Z

0

cursor.execute("select freq from matrix_brown where a_id in (%s) and b_id in (%s)",(b_item_id,b_after_id))

answered Apr 1, 2011 at 18:41

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

Collectives™ on Stack Overflow

Error in mysql query using python script

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related