Python MySQL connector – unread result found when using fetchone

by

All that was required was for buffered to be set to true!

cursor = cnx.cursor(buffered=True)

The reason is that without a buffered cursor, the results are “lazily” loaded, meaning that “fetchone” actually only fetches one row from the full result set of the query. When you will use the same cursor again, it will complain that you still have n-1 results (where n is the result set amount) waiting to be fetched. However, when you use a buffered cursor the connector fetches ALL rows behind the scenes and you just take one from the connector so the mysql db won’t complain.

More Related Contents:

  1. How to insert a space delimited text file into mysql using Python? [closed]
  2. How do I connect to a MySQL Database in Python?
  3. imploding a list for use in a python MySQLDB IN clause
  4. Why do integers in database row tuple have an ‘L’ suffix?
  5. Database does not update automatically with MySQL and Python
  6. How can I change the default Mysql connection timeout when connecting through python?
  7. Python: best practice and securest way to connect to MySQL and execute queries
  8. Not all parameters were used in the SQL statement (Python, MySQL)
  9. Mac OS X – EnvironmentError: mysql_config not found
  10. mysql-python install error: Cannot open include file ‘config-win.h’
  11. Integrating MySQL with Python in Windows
  12. Install mysql-python (Windows)
  13. How to retrieve SQL result column value using column name in Python?
  14. How can I use executemany to insert into MySQL a list of dictionaries in Python
  15. PyMySQL can’t connect to MySQL on localhost
  16. Installing MySQL-python
  17. Executing “SELECT … WHERE … IN …” using MySQLdb
  18. Insert list into my database using Python [duplicate]
  19. Print the actual query MySQLdb runs?
  20. MySQL Improperly Configured Reason: unsafe use of relative path
  21. Python Pandas to_sql, how to create a table with a primary key?
  22. Speeding (Bulk) Insert into MySQL with Python
  23. MySQL Connector could not process parameters
  24. How can I insert NULL data into MySQL database with Python?
  25. How to use python mysqldb to insert many rows at once
  26. Using .aggregate() on a value introduced using .extra(select={…}) in a Django Query?
  27. Warning raised by inserting 4-byte unicode to mysql
  28. Python issue:Unable to find vcvarsall.bat [duplicate]
  29. Context manager for Python’s MySQLdb
  30. What is PyMySQL and how does it differ from MySQLdb? Can it affect Django deployment?

Leave a Comment