Simple Python SQL Query

Question

Simply trying to build a sql query to execute from python. Getting SQL syntax error.

for elem in phraseList:
    cursor.execute("SELECT PHRASE,COUNT(ID) FROM TEST.NERD WHERE LABEL LIKE '%PRT%' \
    AND ID IN (SELECT DISTINCT ID FROM TEST.NERD WHERE LABEL LIKE '%COND%' \
    AND PHRASE LIKE (%s)),(elem)")

However note that when I execute the following (it works perfectly fine):

for elem in phraseList:
    cursor.execute("SELECT PHRASE,COUNT(ID) FROM TEST.NERD WHERE LABEL LIKE '%PRT%' \
    AND ID IN (SELECT DISTINCT ID FROM TEST.NERD WHERE LABEL LIKE '%COND%' \
    AND PHRASE LIKE '%dmg'")

Martijn Pieters · Accepted Answer · 2013-05-08 07:40:47Z

4

You need to make elem a separate parameter, not part of the query string:

cursor.execute("SELECT PHRASE,COUNT(ID) FROM TEST.NERD WHERE LABEL LIKE '%PRT%' \
    AND ID IN (SELECT DISTINCT ID FROM TEST.NERD WHERE LABEL LIKE '%COND%' \
    AND PHRASE LIKE %s", (elem,))

That last parameter needs to be a tuple with one element, and to create one of those you need to have that one comma there too.

answered May 8, 2013 at 7:40

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

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

2 Comments

Yavar Over a year ago

I have posted another problem that I am facing here now stackoverflow.com/questions/16435676/python-sql-valueerror . Thanks for your help once again.

Martijn Pieters Over a year ago

I'm sorry that I didn't catch on to the %PART%, etc. problem there; should have realized this could be the MySQLdb adapter. Answered there.

Collectives™ on Stack Overflow

Simple Python SQL Query

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related