db.executemany('<query>', <coll_of_above>) # Runs execute() many times.

* **Passed values can be of type str, int, float, bytes, None, bool, datetime.date or datetime.datetme.**

from mysql import connector

db = connector.connect(host=<str>, user=<str>, password=<str>, database=<str>)

cursor = db.cursor()

cursor.execute('<query>', <list/tuple>) # Replaces '%s's in query with values.

cursor.execute('<query>', <dict/namedtuple>) # Replaces '%(<key>)s's with values.

<li><strong>Passed values can be of type str, int, float, bytes, None, bool, datetime.date or datetime.datetme.</strong></li>

<div><h3 id="example">Example</h3><pre><code class="python language-python hljs"><span class="hljs-meta">&gt;&gt;&gt; </span>db = sqlite3.connect(<span class="hljs-string">'test.db'</span>)

<span class="hljs-meta">&gt;&gt;&gt; </span>db.execute(<span class="hljs-string">'create table t (a, b, c)'</span>)

<span class="hljs-keyword">from</span> mysql <span class="hljs-keyword">import</span> connector

db = connector.connect(host=&lt;str&gt;, user=&lt;str&gt;, password=&lt;str&gt;, database=&lt;str&gt;)

cursor = db.cursor()

cursor.execute(<span class="hljs-string">'&lt;query&gt;'</span>, &lt;list/tuple&gt;) <span class="hljs-comment"># Replaces '%s's in query with values.</span>

cursor.execute(<span class="hljs-string">'&lt;query&gt;'</span>, &lt;dict/namedtuple&gt;) <span class="hljs-comment"># Replaces '%(&lt;key&gt;)s's with values.</span>