title: python MySQL update specific column fetchall()
body: <p>I'm new to python and I want to update every record that has count 0 in the database. I have tried a lot can't find anything like help.</p>
  
  <pre><code>for row in cur.fetchall():
      if row[3] == 0:
          cur.execute("UPDATE tble SET count = 1 WHERE name = %s" %row[1])
  </code></pre>