On Jan 6, 7:29 pm, Bruno Desthuilliers <bruno. 42.desthuilli...@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. -- http://mail.python.org/mailman/listinfo/python-list