#🔒 mysql.connector.errors.ProgrammingError: Not all parameters were used in the SQL statement

12 messages · Page 1 of 1 (latest)

rapid storm
#

how do i fix this, please help 😭

dim oasisBOT
#

@rapid storm

Python help channel opened

Remember to:

  • Ask your Python question, not if you can ask or if there's an expert who can help.
  • Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
  • Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

Closes after a period of inactivity, or when you send !close.
rapid storm
#

pls help 😭

livid junco
#

are you sure that's the correct parameter format? %s that is

#

and not ? for instance?

high pecan
#

mysql can use %s. However the query values need to be a single tuple

# 
mycursor.execute(query, values)```
dim oasisBOT
#
Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.