Computer Science
To fetch multiple records from the resultset, you may use <cursor>. …………… method.
- fetch()
- fetchmany()
- fetchmultiple()
- fetchmore()
Python MySQL
1 Like
Answer
fetchmany()
Reason — The <cursor>.fetchmany(<n>) method will return only the <n> number of rows from the resultset in the form of a tuple containing the records.
Answered By
2 Likes
Related Questions
To obtain all the records retrieved, you may use <cursor>. …………… method.
- fetch()
- fetchmany()
- fetchall()
- fetchmultiple()
To fetch one record from the resultset, you may use <cursor>. …………… method.
- fetch()
- fetchone()
- fetchtuple()
- none of these
To run an SQL query from within Python, you may use <cursor>. …………… method().
- query()
- execute()
- run()
- all of these
To reflect the changes made in the database permanently, you need to run <connection>. …………… method.
- done()
- reflect()
- commit()
- final()