pymysql fetchall() results as dictionary?

by

PyMySQL includes a DictCursor. It does what I think you want. Here’s how to use it:

import pymysql
import pymysql.cursors
connection = pymysql.connect(db="test")
cursor = connection.cursor(pymysql.cursors.DictCursor)
cursor.execute("SELECT ...")

https://github.com/PyMySQL/PyMySQL/blob/master/pymysql/tests/test_DictCursor.py

More Related Contents:

  1. Python read from txt and save into mysql
  2. Lost connection to MySQL server during query
  3. How to install Python MySQLdb module using pip?
  4. Does Python support MySQL prepared statements?
  5. How to convert SQL Query result to PANDAS Data Structure?
  6. How do I get the “id” after INSERT into MySQL database with Python?
  7. Escape string Python for MySQL
  8. How to install MySQLdb (Python data access library to MySQL) on Mac OS X?
  9. pip install mysqlclient returns “fatal error C1083: Cannot open file: ‘mysql.h’: No such file or directory
  10. Cannot return results from stored procedure using Python cursor
  11. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  12. Inserting a Python datetime.datetime object into MySQL
  13. MySQL — Joins Between Databases On Different Servers Using Python?
  14. How to retrieve SQL result column value using column name in Python?
  15. Using a Python dict for a SQL INSERT statement
  16. RuntimeError: working outside of application context
  17. Insert list into my database using Python [duplicate]
  18. Print the actual query MySQLdb runs?
  19. MySQL Improperly Configured Reason: unsafe use of relative path
  20. Python Pandas to_sql, how to create a table with a primary key?
  21. Speeding (Bulk) Insert into MySQL with Python
  22. MySQL Connector could not process parameters
  23. How do i cast char to integer while querying in django ORM?
  24. flake8 complains on boolean comparison “==” in filter clause
  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. Install mysqlclient for Django Python on Mac OS X Sierra
  28. ‘pip install MySQL-python’ fails with ‘IndexError’
  29. How to insert / retrieve a file stored as a BLOB in a MySQL db using python
  30. How to make mysql connection that requires CA-CERT with sqlalchemy or SQLObject

Leave a Comment