On 20 Apr 2019, at 1:04am, Andy Hegedus <andy.hege...@aghanalytics.com> wrote:
> So is the cursor a 1 use only object? Your question is actually about python, rather than SQLite. You used this construction: > for row in cursor: That means python should go through all the rows that cursor has and do something with each one. Of course, this loop stops once there are no more rows in cursor, so another use of > for row in cursor: will process no more rows because there are no more rows. You can do things like for row in cursor: print(row[1]) print(row[0],row[1]) which will do what you expect. Or you could execute the SELECT twice. Or you could use fetchall twice. You might find this useful: <https://likegeeks.com/python-sqlite3-tutorial/#Select-statement> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
