Very large cursor.rowcount

MySQL database connector for Python programming

Brought to you by: adustman

Very large cursor.rowcount

Forum: Help

Creator: August Bigelow

Created: 2006-06-11

Updated: 2012-09-19

August Bigelow - 2006-06-11

I am getting a very large rowcount from all of my cursor objects and have no idea why. The number is always 18446744073709551615.

Any ideas on what's up?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Andy Dustman - 2006-06-12
  
  Using the standard cursor? What versions of MySQL, MySQLdb, Python? What platform?
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - August Bigelow - 2006-06-12
    
    Sorry for the lack of details. Running MySQL5, Python 2.4, and 1.2.1 of MySQLdb. I'm also using SSDictCursor.
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
    - Andy Dustman - 2006-06-12
      
      cursor.rowcount does not work for SSCursor or any variant until all rows have been fetched.
      
      http://dev.mysql.com/doc/refman/5.0/en/mysql-num-rows.html
      
      If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
      - August Bigelow - 2006-06-12
        
        Doh! That makes such complete sense and I totally spaced it. Thanks a bunch!
        
        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.