Python 使用PyMySQL数据库交互工具，查询MySQL数据表的所有字段(表头)

conn = pymysql.connect(host='127.0.0.1', port=3306, user='user1', password='123456', database='db1',charset='utf8')
cursor = conn.cursor()

sql = "SELECT * FROM students;"
cursor.execute(sql)
col = cursor.description
fields = []
for i in range(len(col)):
    fields.append(col[i][0])
    
cursor.close()
conn.close()

print("students数据表的所有字段：", fields)

===== :运行结果: ================================================

students数据表的所有字段：['id','name','age','gender','score','ranking']