The mysql.connector module in Python provides functions for connecting to a MySQL database and executing SQL statements. When you execute a SELECT statement that retrieves records from a table, you can use the cursor object's description property to get the keys (i.e., column names) of the records in the result set. |
Here's an example of how you can get the keys of the records in the executed result using mysql.connector:
import mysql.connector # Connect to the database conn = mysql.connector.connect( host="hostname", user="username", password="password", database="database_name" ) # Create a cursor cursor = conn.cursor() # Execute a SELECT statement cursor.execute("SELECT * FROM table_name") # Get the keys (column names) of the records keys = [column[0] for column in cursor.description] print(keys) # Fetch the records records = cursor.fetchall() # Iterate over the records and print each one for record in records: print(record) # Close the cursor and connection cursor.close() conn.close() |