How to  unpack only some arguments from zip, not all?
<p>My sql query:</p>

<pre><code> select id,value,zvalue from axis
</code></pre>

<p>gives me result like this: </p>

<pre><code>   ans=(1,23,34)(12,34,35)(31,67,45)(231,3412,234)
</code></pre>

<p>now if i want all these 3 variables as 3 different lists</p>

<pre><code>id,value,zvalue=zip(*ans)
</code></pre>

<p>it will give me 3 separate lists.
but if i only want id and value as separate lists.It will give me TOO MANY VALUES TO UNPACK ERROR.</p>

<pre><code>id,value =zip(*ans)
</code></pre>

<p>is there any way where i can create any number of lists from sql query.because if there are 10 parameters in the query , i have to use all the parameters while using ZIP???
please help</p>
