title: Import multiple lists in MySQL using pymysql (Python)
body: <p>I am trying to insert multiple lists at once in MySQL using pymysql library. I have tried the following:</p>
  
  <pre><code>import pymysql
  
  db = pymysql.connect(host="ipaddress", user="me", passwd="password", db="test") 
  cursor=db.cursor()
  
  list1=[3.1, 4.5, 8.3]
  list2=[1.2, 3.4, 5.2]
  list3=[2.4, 6.5, 6.9]
  
  cursor.executemany("insert into table (var1,var2,var3) values (%f, %f, %f)", [list1,list2,list3])
  db.commit()
  db.close()
  </code></pre>
  
  <p>But I get error. What I am doing wrong?. How should I be doing it?</p>