Use app×
Ask a Question
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE

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

← Prev Question Next Question →
+2 votes
322k views
in Computer by (46.3k points)
closed by

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

Play Quiz Game >

1 Answer

+3 votes
by (49.3k 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. 

← Prev Question Next Question →

Find MCQs & Mock Test

  1. JEE Main 2025 Test Series
  2. NEET Test Series
  3. Class 12 Chapterwise MCQ Test
  4. Class 11 Chapterwise Practice Test
  5. Class 10 Chapterwise MCQ Test
  6. Class 9 Chapterwise MCQ Test
  7. Class 8 Chapterwise MCQ Test
  8. Class 7 Chapterwise MCQ Test

Related questions

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.

Categories

User Contribution to Sarthaks eConnect
Managed by Sarthaks Digitizing India
...