<div>
<pre><code id="code-20-40715573-1">c.execute(select id, col1, col2 from tab1)
print c.fetchall()


or 


c.execute(select id, col1, col2 from tab1)
for i in range(c.rowcount): 
row = c.fetchall()
print row</code></pre>
</div>


c.execute(select id, col1, col2 from tab1)
print c.fetchall()


or 


c.execute(select id, col1, col2 from tab1)
for i in range(c.rowcount): 
row = c.fetchall()
print row

<div>
Thanks plusone3055 <br />
Would you please expand a little? &nbsp;Within th eloop, I want to do one thing with col1 and another with col2.
</div>


Thanks plusone3055
Would you please expand a little?  Within th eloop, I want to do one thing with col1 and another with col2.

<div>
I want to see explicit syntax for getting individual elements off row.<br />
say, printing col1 and col2 in two separate print statements.<br />
<br />
Sorry, a newbie.<br />
Thanks
</div>


I want to see explicit syntax for getting individual elements off row.
say, printing col1 and col2 in two separate print statements.

Sorry, a newbie.
Thanks

<div>
<div class="content wysiwyg-content">
I need an example of python code that does the following<br />
<br />
execute the query &quot;select id, col1, col2 from tab1&quot;<br />
Then Iterate through the query results<br />
&nbsp;<br />
Thanks
</div>
</div>


I need an example of python code that does the following

execute the query "select id, col1, col2 from tab1"
Then Iterate through the query results
 
Thanks

Python loop example

Python is a widely used general-purpose, high-level programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than would be possible in other languages. Python supports multiple programming paradigms, including object-oriented, imperative and functional programming or procedural styles. It features a dynamic type system and automatic memory management and has a large and comprehensive set of standard libraries, including NumPy, SciPy, Django, PyQuery, and PyLibrary.