Write a short note on fetchall( ), fetchone( ) and fetchmany( ) comman

1.	Write a short note on fetchall( ), fetchone( ) and fetchmany( ) commands?
Answer» cursor. fetchall( ) - fetchall ( )method is to fetch all rows from the database table cursor. fetchone( ) – The fetchone ( ) method returns the next row of a query result set or None in case there is no row left. cursor.fetchmany( ) method that returns the next number of rows (n) of the result set.

Write a short note on fetchall( ), fetchone( ) and fetchmany( ) commands?

Answer»

cursor. fetchall( ) - fetchall ( )method is to fetch all rows from the database table cursor.

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

cursor.fetchmany( ) method that returns the next number of rows (n) of the result set.