singlestoredb.connection.Cursor.fetchmany

abstract Cursor.fetchmany(size: Optional[int] = None) → Union[Tuple[Any, ...], Dict[str, Any], pandas.core.frame.DataFrame, List[Tuple[Any, ...]], List[Dict[str, Any]]]

Fetch size rows from the result.

If size is not specified, the arraysize attribute is used.

Examples

>>> while True:
...    out = cur.fetchmany(100)
...    if not len(out):
...        break
...    for row in out:
...        print(row)

Returns

Values of the returned rows if there are rows remaining

Return type

list of tuples