singlestoredb.connection.Cursor.fetchone

abstract Cursor.fetchone() → Tuple[Any, ...] | Dict[str, Any] | np.ndarray | pd.DataFrame | pl.DataFrame | pa.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