# 5X99 XXX 19/7/2024 SBA Library System
# https://mrszeto.net/cprogram/Python-MySQL-project.htm
# program - https://mrszeto.net/cprogram/mysqldb-student.py
# data    - https://mrszeto.net/cprogram/student.txt
import MySQLdb.cursors
conn = MySQLdb.connect(host='localhost', user='root', passwd='', db='test', cursorclass=MySQLdb.cursors.DictCursor)
cursor = conn.cursor()

#-----
sql = "select * from student where class='2A'"
cursor.execute(sql)

for i in cursor.description:
    print(i[0],end=' '*2)
print()

results = cursor.fetchall()
print(results)

for row in results:
    print (f"{row['id']}\t {row['name']:6} {row['class']}")

#-----
cursor.close()
conn.close()