How to get the number of affected rows?

MySQL database connector for Python programming

Brought to you by: adustman

How to get the number of affected rows?

Forum: Help

Creator: Joao Prado Maia

Created: 2001-12-30

Updated: 2012-09-19

Joao Prado Maia - 2001-12-30

Using the normal MySQLdb module, how can I get the number of affected rows for a DELETE statement?

Joao

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Andy Dustman - 2001-12-30
  
  cursor.execute() will return the number of affected rows. You can also look at cursor.rowcount. This is true for any SQL statement (DELETE, INSERT, SELECT, UPDATE, etc.)
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Joao Prado Maia - 2001-12-31
  
  Ah, very cool. Thanks for the information! :)
  
  Joao
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.