conn = mysql.connector.connect(user='root',password='password',host='localhost',database='db',charset='utf8',autocommit=True)
cursor = conn.cursor(buffered=True)
while True:
  cursor.execute("statments")
  sqlData = cursor.fetchone()
  print(sqlData)
  sleep(0.5)

while True:
   conn = mysql.connector.connect(user='root',password='password',host='localhost',database='db',charset='utf8',autocommit=True)
   cursor = conn.cursor(buffered=True)
   cursor.execute("statments")
   sqlData = cursor.fetchone()
   print(sqlData)
   cursor.close()
   conn.close()
   sleep(0.5)