title: Why does PyMySQL delete query execute but does not delete records without error?
body: <p><strong>Issue:</strong></p>
  
  <p>I'm trying to run a delete query using <code>pymysql</code> via my function <code>delEODTmp</code> but it’s not doing anything (i.e. deleting the records). It also does not throw back any errors, making it hard to understand why it is not working.</p>
  
  <p><strong>Troubleshooting:</strong></p>
  
  <p>1) The function retSQL works like a charm, retrieving whatever Select string I throw at it. This confirms that my user login settings are correct input to <code>pymysql.connect</code>. I am doing this from a client to a <code>Mysql 5.7 server</code> on the same network.</p>
  
  <p>2) On the same client connecting to the same server with the same credentials I can:</p>
  
  <ul>
  <li>Run the <code>SQL DELETE FROM t_EOD_tmp;</code> successfully from <code>workbench</code></li>
  <li>Run the <code>SQL DELETE FROM t_EOD_tmp;</code> successfully from <code>phpMyAdmin</code></li>
  </ul>
  
  <p>3) I tried running the py script locally on the server but the delete query still does not work. Same outcome as from client.</p>
  
  <p><strong>Questions:</strong></p>
  
  <p>Seems like destructive queries are being blocked when executed from PyMySQL. 
  Do I need to enable something from Python, from MySQL?</p>
  
  <p>There doesn't seem to be <strong>extensive</strong> documentation on PyMySQL, so maybe it would be better to develop via a different MySQL Python library. Is there a better way?</p>
  
  <p><strong>Code:</strong></p>
  
  <pre><code>import pymysql
  import pandas
  
      query1 = '''SELECT * FROM t_EOD limit 1000;'''
  
      def retSQL(query):
      conn = pymysql.connect(host=myServer, port=myPort, user=myUsr, password=myPwd, db=myDB)
      df = pd.read_sql(query,conn)
      print(df.head(5)) 
      conn.close() # closeSQL connection
  
  def delEODTmp():
      conn = pymysql.connect(host=myServer, port=myPort, user=myUsr, password=myPwd, db=myDB)
      cur = conn.cursor()
      q1 = '''DELETE FROM t_EOD_tmp;'''
      cur.execute(q1) 
          cur.close()
          conn.close()
  
  retSQL(query1)
  delEODTmp()
  </code></pre>