How to retrieve SQL result column value using column name in Python?

by

The MySQLdb module has a DictCursor:

Use it like this (taken from Writing MySQL Scripts with Python DB-API):

cursor = conn.cursor(MySQLdb.cursors.DictCursor)
cursor.execute("SELECT name, category FROM animal")
result_set = cursor.fetchall()
for row in result_set:
    print "%s, %s" % (row["name"], row["category"])

edit: According to user1305650 this works for pymysql as well.

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. Python MySQL connector – unread result found when using fetchone
  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. 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. How can I insert NULL data into MySQL database with Python?
  22. How to use python mysqldb to insert many rows at once
  23. Using .aggregate() on a value introduced using .extra(select={…}) in a Django Query?
  24. Warning raised by inserting 4-byte unicode to mysql
  25. django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
  26. pymysql fetchall() results as dictionary?
  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