Row count always prints as -1 while select values from the database using python script

Question

I need to print the row count of the cursor while using select query using python. But it always returns -1 even the select query returns some values.

Code I've tried:

    cursor = conn.cursor()
    cursor.execute(query)
    print(cursor.rowcount)

How to print the rowcount of the cursor?

Are you using sqlite3, if so read this docs.python.org/3/library/sqlite3.html#sqlite3.Cursor.rowcount — Hari Krishnan

ArockiaRaj ArockiaRaj · Accepted Answer · 2018-09-06T06:13:52

1

votes

The below code returns the lenth of the row.

  rows = cursor.fetchall()
  len(rows)

Row count always prints as -1 while select values from the database using python script

2 Answers