singlestoredb.connection.Cursor.fetchall

abstract Cursor.fetchall() → Tuple[Any, ...] | Dict[str, Any] | np.ndarray | pd.DataFrame | pl.DataFrame | pa.Table | List[Tuple[Any, ...]] | List[Dict[str, Any]]

Fetch all rows in the result set.

Examples

>>> for row in cur.fetchall():
...     print(row)

Returns:

• list of tuples – Values of the returned rows if there are rows remaining

• None – If there are no rows to return