Login Register

sqlite3.Cursor.fetchall()

fetchall()

Fetches all (remaining) rows of a query result, returning a list. Note that the cursor’s arraysize attribute can affect the performance of this operation. An empty list is returned when no rows are available.

Links:

https://docs.python.org/3.5/library/sqlite3.html#sqlite3.Cursor.fetchall

doc_python

2016-10-07 17:42:39

Comments

Leave a Comment

Please login to continue.

Popular Articles

sqlite3.Cursor class sqlite3.Cursor A Cursor instance has the following attributes and methods. execute(sql[, parameters]) Executes an SQL statement. The SQL

sqlite3.Cursor.connection connection This read-only attribute provides the SQLite database Connection used by the Cursor object. A Cursor object created by calling con.curs

sqlite3.Cursor.description description This read-only attribute provides the column names of the last query. To remain compatible with the Python DB API, it returns a 7-tupl

sqlite3.Cursor.fetchmany() fetchmany(size=cursor.arraysize) Fetches the next set of rows of a query result, returning a list. An empty list is returned when no more rows are

sqlite3.Cursor.lastrowid lastrowid This read-only attribute provides the rowid of the last modified row. It is only set if you issued an INSERT statement using the execute