title: How to use INSERT each row of a list to mySQL from Python?
body: <p>I have a list of data and need to insert each row back to MySQL. Below is an example of my data.</p>
  
  <pre><code>print(data[1:5])
  
  [['Abilene, TX', 'Ahwatukee Foothills, AZ', 922.41258034], 
  ['Abilene, TX', 'Akron, OH', 1494.34762588], 
  ['Abilene, TX', 'Alafaya, FL', 1381.55219389], 
  ['Abilene, TX', 'Alameda, CA', 1680.9984747]]
  </code></pre>
  
  <p>My SQL columns are City, Destination, distance and so far I have:</p>
  
  <pre><code>for i in range(len(data)):
  mycursor.execute("INSERT INTO table Shark (City, Destination, Distance) VALUES (:data)",[i])
  </code></pre>
  
  <p>which gives me an error "Not all parameters were used in the SQL Statment". How would I fix this? </p>