Insert multiple rows into DB with Python list of Tuples
<p>I have a list of tuples:</p>

<pre><code>list_ = [(1,7,3000),(1,8,3500), (1,9,3900)]
</code></pre>

<p>I want to update a table with multiple rows/values for a given ID (in this case ID = 1)</p>

<p>So:</p>

<pre><code>INSERT INTO table (ID, Speed, Power) VALUES (1,7,3000),(1,8,3500),(1,9,3900)
</code></pre>

<p>I'm having trouble with the format - I've gotten the string down to something like this: </p>

<pre><code>INSERT INTO ... VALUES ((1,7,3000),(1,8,3500),(1,9,3900))
</code></pre>

<p>But of course this doesn't work due to the extra parenthesis wrapped around the tuples. Any ideas for constructing a way to do this "pythonically? </p>