从表中查询数据

import pymysql
# 创建与数据库连接
con = pymysql.connect(host = 'localhost',user = 'root',password = '123456',database = 'python_db',port = 3306)
# 创建游标
cur = con.cursor()
# 编写查询的sql
sql = 'select * from python_data '
# 执行sql
try:
    cur.execute(sql)
    #处理结果集
    # student = cur.fetchone()   #只能查询到一个结果
    # print(student)



    students = cur.fetchall()   #获取所有的信息
    print(students)
    for student in students:
        # print(student)
        id = student[0]
        name = student[1]
        age = student[2]
        score = student[3]
        print('名次:',id,'姓名',name,'年龄：',age,'分数：',score)



except Exception as e:
    print(e)
    print('查询失败')
finally:
    con.close()