sqlite3.Cursor.fetchmany()
sqlite3.Cursor.fetchmany() is a Python method in the SQLite Module category. Fetches up to `size` rows as a list of tuples. The syntax is cursor.fetchmany(size=1). Parameters: size — number of rows. Returns: List of tuples. A typical example: batch = cur.fetchmany(100) # Get 100 rows at a time. A close sibling is sqlite3.connect(), which connects to an SQLite database file (or creates it). Returns a Connection object. A close sibling is sqlite3.Connection.execute(), which executes a single SQL statement and returns a Cursor. A close sibling is sqlite3.Connection.cursor(), which creates a Cursor object for database operations. A close sibling is sqlite3.Cursor.execute(), which executes a SQL statement with optional parameter substitution. More about this category: SQLite database — connect, execute, commit, fetchone, fetchall, Row. Related SQLite Module entries: sqlite3.connect(), sqlite3.Connection.execute(), sqlite3.Connection.cursor(), sqlite3.Cursor.execute(), sqlite3.Cursor.executemany(), sqlite3.Cursor.fetchone(). This page is part of the free Python Reference documentation covering 978+ functions, methods, and modules with examples and parameter details.