Is there some methods like 'datareader' in MySQLdb for handling mass data
you680 at gmail.com
Tue Jan 6 14:00:36 CET 2009
On Jan 6, 7:29 pm, Bruno Desthuilliers <bruno.
42.desthuilli... at websiteburo.invalid> wrote:
> Jeremy.Chen a écrit :
> > hi all:
> > when I handled mass data table in mysql with python's MySQLdb lib,
> > something frustrated me. I could't find any function like datareader,
> > which yield one row by recording rows' anchor ,after each time I
> > invoked 'read()' in a loop.
> I think you want cursor.fetchone(). But read below...
> > fetchall or fetchmany just fetched all data
> > in once, which take so much memory when meeting one mass data
> > table.
> The cursor object is it's own iterator. So you just have to do:
> for row in cursor:
That's what I want.
I see,cursor also can be a iterator.
More information about the Python-list