MySQL: Get column name or alias from query

by

cursor.description will give you a tuple of tuples where [0] for each is the column header.

num_fields = len(cursor.description)
field_names = [i[0] for i in cursor.description]

More Related Contents:

  1. Installing specific package version with pip
  2. Database does not update automatically with MySQL and Python
  3. mysql-python install error: Cannot open include file ‘config-win.h’
  4. How to insert pandas dataframe via mysqldb into database?
  5. Install mysql-python (Windows)
  6. When to close cursors using MySQLdb
  7. Python MYSQL update statement
  8. Python 3.4.0 with MySQL database
  9. How can I use executemany to insert into MySQL a list of dictionaries in Python
  10. ImportError: No module named MySQLdb
  11. Print the actual query MySQLdb runs?
  12. Can’t install mysql-python (newer versions) in Windows
  13. Dynamic SQL Queries with Python and mySQL
  14. What’s the difference between MySQLdb, mysqlclient and MySQL connector/Python?
  15. How to use python mysqldb to insert many rows at once
  16. ‘pip install MySQL-python’ fails with ‘IndexError’
  17. What is PyMySQL and how does it differ from MySQLdb? Can it affect Django deployment?
  18. How to disable query cache with mysql.connector
  19. pip install mysql-python fails with EnvironmentError: mysql_config not found
  20. Lost connection to MySQL server during query
  21. Does Python support MySQL prepared statements?
  22. How do I get the “id” after INSERT into MySQL database with Python?
  23. Cannot return results from stored procedure using Python cursor
  24. How to retrieve SQL result column value using column name in Python?
  25. Python and MySQLdb: substitution of table resulting in syntax error
  26. Bulk insert with SQLAlchemy ORM
  27. RuntimeError: working outside of application context
  28. cursor.fetchall() vs list(cursor) in Python
  29. How do i cast char to integer while querying in django ORM?
  30. flake8 complains on boolean comparison “==” in filter clause

Leave a Comment