title: How insert a list as a column in MySQL with Python?
body: <p>So basically I have this list :</p>
  
  <pre><code>L1 = ['hel-lo', 'world123', 'bye', 'python']
  </code></pre>
  
  <p>I want to insert this list in my MySQL table, as follow :</p>
  
  <pre><code>+-------------------------+
  |          words          |
  +-------------------------+
  | hel-lo                  |
  | world123                |
  | bye                     |
  | python                  |
  +-------------------------+
  </code></pre>
  
  <p>In reality, my list is composed of about 1000 elements. 
  I tried many things which I found on StackOverflow, but nothing is working. (It seems that the elements are trying to be insert with this format  "['string']").</p>
  
  <p>Last solution I tried :</p>
  
  <pre><code>values = [list([item]) for item in L1]
  cursor.executemany(u"INSERT INTO `table`(`data`) VALUES %s", values)
  </code></pre>
  
  <p>Which returns this error :</p>
  
  <pre><code> mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''hel-lo')' at line 1
  </code></pre>
  
  <p>Any advices are welcomed !</p>