Question

Mention the difference between fetchone( ) and fetchmany( )

Answer 1

Displaying A record using fetchone( )

The fetchone( ) method returns the next row of a query result set or None in case there is no row left.

Example

import sqlite3

connection= sqlite3 ,connect(“Academy.db”)

cursor = connection.cursor( )

cursor.execute(“SELECT * FROM student”) 

print(“\nfetch one:”) 

res = cursor. fetchone( )

print(res)

OUTPUT

fetch one:

(1, ‘Akshay’ , ’B’ , ’M’ , 87.8, ‘2001-12-12’) 

Displayingusing fetchmany( )

Displaying specified number of records is done by using fetchmany( ).This method returns the next number of rows (n) of the result set. 

Example : Program to display the content of tuples using fetchmany( )

import sqlite3

connection = sqlite3.connect(” Academy, db”) 

cursor = connection. cursor( ) 

cursor.execute(“SELECT * FROM student”) 

print(“fetching first 3 records:”)

result= cursor. fetchmany(3)

print( result)

OUTPUT

fetching first 3 records:

[ (1, ‘Akshay’ , ’B’ , ‘M’ , 87.8, ‘2001-12-12’), (2, ‘Aravind’ , ‘A’ , ’M’ , 92.5, ‘2000-08-17’), (3, ‘BASKAR’, ‘C, TVT, 75.2, ‘1998-05-17’)]