title: PyMySQL returning old/snapshot values/not rerunning query?
body: <p>I'm using <code>pymysql.cursors</code> and a simplified code example that loads a row from a table and prints it every second is:</p>
  
  <pre><code>#!/usr/bin/env python3
  import pymysql.cursors
  import time
  
  conn = pymysql.connect(host='localhost',
       # credentials etc.
       cursorclass=pymysql.cursors.DictCursor)
  
  while True:
      with conn.cursor() as cursor:
          cursor.execute("SELECT * FROM state limit 1;")
          vals = cursor.fetchone()
          print (vals)
          time.sleep(1)
  </code></pre>
  
  <p><strong>state</strong> is a table with a single row in a MariaDb database.</p>
  
  <p>Now while this is running if I fire up a MySQL client and change the table's contents, this script merrily keeps pumping out the original value; i.e. it's apparently not consulting the database(!).</p>
  
  <p>I'm newish to Python and I'm definitely new to PyMySQL, so apols if this is a daft question but I have <a href="https://www.python.org/dev/peps/pep-0249/#id15" rel="noreferrer">RTM</a> a bit and it just looks odd.</p>