Question

Mention the difference between fetchone() and fetchmany().

Answer 1

fetchone()	fetchmany()
The fetchone() method returns the next row of a query result set	fetchmany() method returns the next number of rows (n) of the result set.
Example: r = cursor. fetchoneQ	Example: r = cursor. fetchmanyQ)