Scribd
Upload
51 views1 page

MySQL - Python Connection-By S Dutta

This Python code connects to a MySQL database, retrieves login history data from a table, stores it in a list, and prints out field names and a record.

Uploaded by

bishwaj
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
51 views1 page

MySQL - Python Connection-By S Dutta

This Python code connects to a MySQL database, retrieves login history data from a table, stores it in a list, and prints out field names and a record.

Uploaded by

bishwaj
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

import mysql.

connector

rec = []

cnx = [Link](user='ideation', password='Admin@123',


host='[Link]',
database='ideation')
cursor = [Link]()

[Link]("select * from login_history")

field_names = [i[0] for i in [Link]]

for row in cursor:


print (row)
[Link](row)

[Link]()
[Link]()

print(field_names)
print (rec[5][1])

You might also like