Is there some methods like 'datareader' in MySQLdb for handling mass data

Jeremy.Chen 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:
>
> cursor.execute(your_query)
> for row in cursor:
>     process(row)
>
> HTH

That's what I want.
I see,cursor also can be a iterator.



More information about the Python-list mailing list