title: MySQL not updating after calling connection.commit() with Flask (WORKING)
body: <p>I'm using flask to build a simple web app but for whatever reason the conn.commit() is not committing the data into the database. I know this because when I manually add something to the database the data doesn't change but the ID section increases each time I test it (because its using auto increment). So basically my current table has ID 1, Username test, Password test and the next entry that I inserted manually (after trying to use my application) was ID 5, Username blah, Password blah. Is there any specific reason that the commit isn't working?</p>
  
  <p>EDIT: I had to change cursor = mysql.connect().cursor() to conn.cursor()</p>
  
  <pre><code>@app.route('/add_data/')
  def add_tv_to_database():
      conn = mysql.connect()
      cursor = mysql.connect().cursor()
      cursor.execute("INSERT INTO _accounts VALUES (null, 'test','test')")
      conn.commit()
      return render_template('index.html')
  </code></pre>