singlestoredb.connection.Cursor.fetchone

abstract Cursor.fetchone() → Tuple[Any, ...] | Dict[str, Any] | numpy.ndarray | pandas.DataFrame | polars.DataFrame | pyarrow.Table | List[Tuple[Any, ...]] | List[Dict[str, Any]] | None

Fetch a single row from the result set.

Examples

>>> while True:
...    row = cur.fetchone()
...    if row is None:
...       break
...    print(row)

Returns:

Values of the returned row if there are rows remaining

Return type:

tuple