title: how to use rowcount in mysql using python
body: <p>We are implementing a database in a student record project. We want to see that how many rows are there in a table before and after deleting a row from a table. 
  The code we tried is as follows:</p>
  
  <pre><code>1  roll=5
  2  m = mysql.connector.connect(host='localhost', database='student',user='root', password='')
  3  cur = m.cursor()
  4  rc = cur.rowcount
  5  print("%d"%rc)
  6  e=cur.execute("DELETE FROM `acc_details` WHERE roll_No=%s" % roll)
  7  print("%d"%cur.rowcount) 
  </code></pre>
  
  <p>In the above code, the first rowcount in line 4 is giving -1 as the output and the rowcount in the last line is giving the no of rows that the table has after deleting a row.</p>
  
  <p>Why is the first rowcount in line 4 give -1 as the output?</p>
  
  <p>Any help shall be great. </p>