title: Python: How to get number of rows deleted with MySQLdb
body: <p>I have this below code which deletes all the rows in a table whose date column value is current_date. </p>
  
  <pre><code>db = MySQLdb.connect("localhost",'root','XXXX','XXXX')
  cur = db.cursor()
  query = "delete from RealTimeData where date = current_date()"
  cur.execute(query)
  db.commit()
  </code></pre>
  
  <p>Now, How can I know that How many rows did my query delete from table? 
  I tried <code>fetchone()</code> it was returning <code>None</code></p>