Capture output from a mysql select statement using python
<p>Using Python2.4 I want to capture output from a mysql command. One caveat is that I need to pipe the SQL statement using an echo.</p>

<pre><code>echo 'SELECT user FROM mysql.user;' | mysql
</code></pre>

<p>I see example using call, os.system, popen but what is best to use for my version of python and capturing the output in a tuple.</p>

<p>Thanks</p>
