Python Mysql, “commands out of sync; you can’t run this command now”

by

Thanks to JoshuaBoshi for his answer, which solved the problem. After calling the procedure, I had to close the cursor and open it again before using it to execute another statement:

cursor.close() 

cursor = connection.cursor()

The cursor can be closed immediately after fetchall(). The result set still remains and can be looped through.

More Related Contents:

  1. mysql to pdf – python or ruby [closed]
  2. Installing specific package version with pip
  3. How can I connect to MySQL in Python 3 on Windows?
  4. Python & MySql: Unicode and Encoding
  5. Authentication plugin ‘caching_sha2_password’ is not supported
  6. How to disable SQLAlchemy caching?
  7. Setting Django up to use MySQL
  8. memory-efficient built-in SqlAlchemy iterator/generator?
  9. How can I insert data into a MySQL database?
  10. How to use MySQLdb with Python and Django in OSX 10.6?
  11. When to close cursors using MySQLdb
  12. How to enable MySQL client auto re-connect with MySQLdb?
  13. How to build a flask application around an already existing database?
  14. How to efficiently use MySQLDB SScursor?
  15. Python MySql Insert not working
  16. What is the best solution for database connection pooling in python?
  17. How to run Django’s test database only in memory?
  18. Using MySQL in Flask
  19. trapping a MySql warning
  20. Repeated MySQL queries from Python return the same data [duplicate]
  21. Can one use the Django database layer outside of Django?
  22. Python mySQL Update, Working but not updating table
  23. ImportError: No module named ‘MySQL’
  24. Python import MySQLdb error – Mac 10.6
  25. mysql-python installation problems (on mac os x lion)
  26. Simple Subquery with OuterRef
  27. Python JSON encoder to support datetime?
  28. django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
  29. ‘pip install MySQL-python’ fails with ‘IndexError’
  30. How to insert / retrieve a file stored as a BLOB in a MySQL db using python

Leave a Comment