Computer Science
To execute all the rows from the result set, which method is used?
- fetchall()
- fetchone()
- fetchmany()
- none of these
Python MySQL
2 Likes
Answer
fetchall()
Reason — The fetchall() method retrieves all the rows in a result set and returns them as a list of tuples.
Answered By
1 Like
Related Questions
Which command is used for counting the number of rows in a database?
- row
- rowcount
- count()
- row_count
Name the method which is used for displaying only one record from the result set.
- fetchmany()
- fetchno()
- fetchall()
- fetchone()
Pick the correct username used for logging in database.
- root
- local
- directory
- host
Name the host name used for signing in the database.
- localhost
- localpost
- localcost
- none of these