Methods to fetch records in python fetchone fetchall

 

Fetching Data

After executing the SQL statement for reading records from a table, either of the following methods can be used to retrieve them in python.

1. fetchone: It retrieves one record at a time in the form of a tuple.

2. fetchall: It retrieves all fetched records at a point in the form of tuple of tuples.