Python Unable to Find SQL Value From Database

Question

I have been working with an SQL database through the mySQL library in Python. I have recently found that when I try searching for a string in my database, it is not correctly returning the output I expect. I think this may be due to my variable not being properly inserted into my SQL command.

code = data['code']
sql = "SELECT 200 FROM mytable WHERE mycolumn = '%s';"
query.execute(sql, teamCode)
print(str(query.fetchall()))

My problem is that printing query.fetchall() prints an empty list ([]) instead of the expected [[200,]] which means the program thinks the code value it is using does not exist in the SQL database, which it does.

Tim Roberts · Accepted Answer · 2021-06-21 19:53:52Z

1

The parameters in an execute call need to be a sequence, like a tuple. Try:

query.excute(sql, (teamCode,))

That turns it into a one-element tuple. BTW, did you really mean "code" there?

answered Jun 21, 2021 at 19:53

Tim Roberts

55.3k4 gold badges28 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

Python Unable to Find SQL Value From Database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related