python获取返回值

Question

python执行完之后返回的值要怎么样才能一个个取出来呢

返回值

Answer 1

for循环遍历查询结果

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='root', password='password', db='test', charset='utf8mb4')
cursor = conn.cursor()

# 查询数据
sql = "SELECT * FROM students"
cursor.execute(sql)
results = cursor.fetchall()

# 遍历查询结果并输出
for row in results:
    for col in row:
        print(col, end='\t')
    print()

# 关闭数据库连接
cursor.close()
conn.close()