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