CODEWITHSUNDEEP
pythonmysql
vincseize
vincseize

Reputation: 11

Python Mysql Request with variables

I have used python for a long time but I have trouble with a particular string-variable manipulation case

I want to do something like this:

##################################

#sample
MYROW= 'ID_project'

result=curs.execute("""select %s FROM shotmanager_projects""",(MYROW))

#result=curs.execute("""select %s FROM shotmanager_projects""",('ID_sample')) 
# don t work too

###################################

And it doesnt work at all!

Why isn't % var not accepted in this case?

Upvotes: 1

Views: 145

Answers (2)

Corey Goldberg
Corey Goldberg

Reputation: 60644

result = curs.execute("select %s FROM shotmanager_projects", (MYROW,))

Upvotes: 0

Ignacio Vazquez-Abrams
Ignacio Vazquez-Abrams

Reputation: 799450

(x) is not a tuple with one element, it is a normal value. (x,) is a tuple with one element.

Upvotes: 3

Related Questions