singlestoredb.connection.Cursor.fetchall

abstract Cursor.fetchall() → Union[Tuple[Any, ...], Dict[str, Any], pandas.core.frame.DataFrame, 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