Python MySQL Connector database query with %s fails

by

Change your funcursor.execute(query, uName) call to:

funcursor.execute(query, (uName, ))

The second argument in execute takes a list/tuple of strings, not a string. The above call creates the tuple before passing in the string to execute, so no error is thrown.

The reason why execute takes a list/tuple of strings is because it does not know beforehand how many strings it needs in order to satisfy your query.

More Related Contents:

  1. Writing to MySQL database with pandas using SQLAlchemy, to_sql
  2. Python call sql-server stored procedure with table valued parameter
  3. How to get a single result from a SQL query in python?
  4. Python mySQL Update, Working but not updating table
  5. MySQL Connector could not process parameters
  6. What’s the difference between MySQLdb, mysqlclient and MySQL connector/Python?
  7. Escape SQL “LIKE” value for Postgres with psycopg2
  8. Accepting only letters as input [closed]
  9. Making a checkers board in python [closed]
  10. Tell me how to replace python data, How can I read the a.txt file and make it in the following format? [closed]
  11. How to iterate over rows in a DataFrame in Pandas
  12. How to get a string after a specific substring?
  13. can we use XPath with BeautifulSoup?
  14. Check if a number is a perfect square
  15. Pandas read nested json
  16. Underscore _ as variable name in Python [duplicate]
  17. Python 3.7 – asyncio.sleep() and time.sleep()
  18. How to format date string via multiple formats in python
  19. Can pandas groupby aggregate into a list, rather than sum, mean, etc?
  20. How to run celery on windows?
  21. ‘staticmethod’ object is not callable
  22. What does it mean that Python comparison operators chain/group left to right?
  23. What is a “callable” in Python?
  24. How to log raw HTTP request/response in Python FastAPI?
  25. How can I import from the standard library, when my project has a module with the same name? (How can I control where Python looks for modules?)
  26. how to concat two data frames with different column names in pandas? – python
  27. Pandas – Interleave / Zip two DataFrames by row
  28. How to limit the size of a comprehension?
  29. Issue with merging multiple JSON files in Python
  30. Mac + virtualenv + pip + postgresql = Error: pg_config executable not found

Leave a Comment