Sarthaks APP
+1 vote
in Computer by (48.3k points)
closed by

Differentiate between fetchone() and fetchall() methods with suitable examples for each.

1 Answer

+2 votes
by (50.9k points)
selected by
Best answer

fetchall() fetches all the rows of a query result. An empty list is returned if there is no record to fetch the cursor. 

fetchone() method returns one row or a single record at a time. It will return None if no more rows / records are available. 

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.