Imagine I have a mysql cursor and data read. The amount of data might be very big that I want to deal with one line each time.
An easy and straight forward way might be like this:
while True:
row = cursor.fetchone()
if not row: break
.....
But this doesn't look good, so I wonder whether this way works as imagined:
for row in iter(cursor.fetchall())
The thing I want to know is: if I use the iter(cursor.fetchall())
way, does it fetch all the data first or it just fetch one row at a time?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…