How to traverse a query result in python?

Vote count:

0

This is a general question, consider I have a table with a number of columns like:

serial_number    time          number_1    number2
1                14:00:00       123             124
2                13:00:34       121             11111

with a million rows. I want to get the result of a query like:

SELECT * from table if time = "14:00:00";

the result of this is a tuple of tuples, how will I traverse the result and process it in python, can you please point to me some on doing this.

asked 19 secs ago

Rahul Nair

22

How to traverse a query result in python?