title: Python 3 MySQL using question mark placeholders
body: <p>I am looking for a way to drop values from a list into a prepared SQL string which has question marks as placeholders.  I have used this before in PyQT, but there I use the bindValue function.  Using pymysql there looks to be no such function.  </p>
  
  <p>Here's an example of the type of SQL string I have prepared:</p>
  
  <pre><code>INSERT INTO my_table (`Column1Name`, `Column2Name`, `Column3Name`) VALUES (?,?,?);
  </code></pre>
  
  <p>I then have a list of values I am looking to insert into (or link to) the question mark placeholders.</p>
  
  <pre><code>my_values_list['string_1', '3', 'anothervalue']
  </code></pre>
  
  <p>Like I say, I have used this method before in PyQT, so I know this '?' placeholder method works, but without the bindValue function I can't see how to get it to work using pymysql.</p>
  
  <p>Here's how I got it to work using PyQT's QSqlQuery bindValues function if it helps, where query.exec_() executes the SQL string:</p>
  
  <pre><code>if my_values_list:
          [self.query.bindValue(i, my_values_list[i]) for i in range(len(my_values_list))]
  self.query.exec_()
  </code></pre>