python mysql中for循环语句

import mysql.connector

# 连接到MySQL数据库
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

# 创建游标对象
mycursor = mydb.cursor()

# 执行SQL查询
mycursor.execute("SELECT * FROM yourtable")

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

# 执行SQL查询
mycursor.execute("SELECT * FROM yourtable")

# 获取查询结果
result = mycursor.fetchall()

# 检查结果是否为空
if result:
  for row in result:
    print(row)
else:
  print("No data found")

import time

while True:
  try:
    # 连接到MySQL数据库
    mydb = mysql.connector.connect(
      host="localhost",
      user="yourusername",
      password="yourpassword",
      database="yourdatabase"
    )

    # 创建游标对象
    mycursor = mydb.cursor()

    # 执行SQL查询
    mycursor.execute("SELECT * FROM yourtable")

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

    # 关闭连接
    mycursor.close()
    mydb.close()

    # 等待一段时间再重新连接
    time.sleep(60)
  except mysql.connector.Error as err:
    print(f"Error: {err}")