Get total number of records

    db1cursor.execute("""SELECT count(*) FROM tbl_my_table 
                      """)
    row = db1cursor.fetchone()
    if row == None:
        return(None)
    
    total_records = row[0]
    #print("Total captured images: ", total_records)
    
    return(total_records)
Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.

Comments

Your email address will not be published. Required fields are marked *