querying mysql database in python where table is a variable

Question

I am aware this may be a duplicate post. However I have looked at the other posts and cant figure it out in my case.

from configdata import configdata

from dbfiles.dbconnect import connection 

c,conn = connection()

table = configdata()[4]
userid = 'jdeepee'

value = c.execute("SELECT * FROM %s WHERE userid = (%s)" % (table), userid)

print(value)

I think the code is self explanatory. But essentially what I am trying to do is query a MySQL database based on a variable for the integer and userid. I believe my syntax is wrong not sure how to fix it however. Help would be great.

I have tried to do that, I think it is the user id causing some issues. I get the error: TypeError: not enough arguments for format string — Joshua
– Joshua, Commented Dec 7, 2015 at 21:17
I am curious. Why would you have code which reads a row from any table? If table is unknown in some part of code, the resulting row data will also contain unknown columns. How do you use that? — zvone
– zvone, Commented Dec 7, 2015 at 22:08

Eugene Yarmash · Accepted Answer · 2015-12-07 22:13:26Z

1

Try this:

value = c.execute("SELECT * FROM {} WHERE userid = %s".format(table), (userid,))

Basically, you need to interpolate the table name into the query first, then pass any query parameters to .execute() in a tuple.

edited Dec 7, 2015 at 22:13

answered Dec 7, 2015 at 21:20

Eugene Yarmash

152k44 gold badges346 silver badges391 bronze badges

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

Collectives™ on Stack Overflow

querying mysql database in python where table is a variable

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