python mysql中for循环

import mysql.connector

# 连接数据库
cnx = mysql.connector.connect(user='username', password='password',
                              host='localhost', database='database_name')

cursor = cnx.cursor()

# 执行查询
query = "SELECT * FROM table_name"
cursor.execute(query)

# 使用for循环遍历查询结果
for row in cursor:
    print(row)

# 关闭连接
cursor.close()
cnx.close()

import mysql.connector

try:
    # 连接数据库
    cnx = mysql.connector.connect(user='username', password='password',
                                  host='localhost', database='database_name')
    cursor = cnx.cursor()

    # 执行查询
    query = "SELECT * FROM table_name"
    cursor.execute(query)

    # 使用for循环遍历查询结果
    for row in cursor:
        print(row)
finally:
    # 关闭连接
    if cursor:
        cursor.close()
    if cnx:
        cnx.close()