Python: use mysqldb to import a MySQL table as a dictionary?

by

MySQLdb has a separate cursor class for this, the DictCursor. You can pass the cursor class you want to use to MySQLdb.connect():

import MySQLdb.cursors
MySQLdb.connect(host="...", cursorclass=MySQLdb.cursors.DictCursor)

More Related Contents:

  1. How do I merge two dictionaries in a single expression (take union of dictionaries)?
  2. Iterating over dictionaries using ‘for’ loops
  3. Delete an element from a dictionary
  4. PyInstaller, spec file, ImportError: No module named ‘blah’
  5. How to merge multiple dicts with same key or different key?
  6. Rename a dictionary key
  7. Modifying a Python dict while iterating over it
  8. Safe method to get value of nested dictionary
  9. How to convert an XML string to a dictionary?
  10. How to sum dict elements
  11. Extract subset of key-value pairs from dictionary?
  12. How does the key argument in python’s sorted function work?
  13. Enable Python to Connect to MySQL via SSH Tunnelling
  14. Convert a python dict to a string and back
  15. How do I escape % from python mysql query
  16. sort dict by value python [duplicate]
  17. Is there anything faster than dict()?
  18. Remove an item from a dictionary when its key is unknown
  19. Using Django database layer outside of Django?
  20. Python: Elegantly merge dictionaries with sum() of values [duplicate]
  21. Efficient way to remove keys with empty strings from a dict
  22. How to convert a list to a dictionary with indexes as values?
  23. “unpacking” a passed dictionary into the function’s name space in Python?
  24. How to detect if any element in a dictionary changes?
  25. Python Pickling Dictionary EOFError
  26. Is the order of a Python dictionary guaranteed over iterations?
  27. Know the depth of a dictionary
  28. How to extract all values from a dictionary in Python?
  29. Determine whether a key is present in a dictionary [duplicate]
  30. Comparing 2 lists consisting of dictionaries with unique keys in python

Leave a Comment