How to efficiently use MySQLDB SScursor?

by

I am in agreement with Otto Allmendinger’s answer, but to make explicit Denis Otkidach’s comment, here is how you can iterate over the results without using Otto’s fetch() function:

import MySQLdb.cursors
connection=MySQLdb.connect(
    host="thehost",user="theuser",
    passwd="thepassword",db="thedb",
    cursorclass = MySQLdb.cursors.SSCursor)
cursor=connection.cursor()
cursor.execute(query)
for row in cursor:
    print(row)

More Related Contents:

  1. Fastest way to list all primes below N
  2. MySQL parameterized queries
  3. PyInstaller, spec file, ImportError: No module named ‘blah’
  4. How to insert pandas dataframe via mysqldb into database?
  5. How to iterate over a list in chunks
  6. Load CSV data into MySQL in Python
  7. Enable Python to Connect to MySQL via SSH Tunnelling
  8. UnicodeEncodeError: ‘latin-1’ codec can’t encode character
  9. How to replace Django’s primary key with a different integer that is unique for that table
  10. Writing to MySQL database with pandas using SQLAlchemy, to_sql
  11. When is not a good time to use python generators?
  12. Django : Table doesn’t exist
  13. Python MYSQL update statement
  14. Python Mysql, “commands out of sync; you can’t run this command now”
  15. How do I escape % from python mysql query
  16. Efficient way to take the minimum/maximum n values and indices from a matrix using NumPy
  17. Python Pandas write to sql with NaN values
  18. Python: MySQLdb and “Library not loaded: libmysqlclient.16.dylib”
  19. How to filter (or replace) unicode characters that would take more than 3 bytes in UTF-8?
  20. scipy is not optimizing and returns “Desired error not necessarily achieved due to precision loss”
  21. Python: use mysqldb to import a MySQL table as a dictionary?
  22. InterfaceError (0, ”)
  23. What’s the difference between MySQLdb, mysqlclient and MySQL connector/Python?
  24. Remove duplicates in list of object with Python
  25. Scikit Learn GridSearchCV without cross validation (unsupervised learning)
  26. Python equivalence to inline functions or macros
  27. Python issue:Unable to find vcvarsall.bat [duplicate]
  28. Context manager for Python’s MySQLdb
  29. Retrieve query results as dict in SQLAlchemy
  30. What is PyMySQL and how does it differ from MySQLdb? Can it affect Django deployment?

Leave a Comment