title: Python mysql-connector multi insert not working?
body: <p>I just started using the Mysql Connector library for Python and I seem to be running into an issue I can't get my head around.</p>
  
  <p>I have Python dynamically generate Insert statements to be executed on MySQl database. </p>
  
  <p>I batch them together in one string and then I execute every n together in the one <code>cusrsor.execute()</code> statement however for some reason when I check the DB and table, the new rows are nowhere to be found. </p>
  
  <p>I tried it with even just two insert statements together and they still didn't get persisted to the DB even though I call execute, call a commit and then close the cursor and connection in that order. </p>
  
  <p>If I have just one insert statement in the execute command and I remove the multi flag then it works fine.</p>
  
  <p>Does anyone know why this could be happening?</p>
  
  <p>Sample code: </p>
  
  <pre><code>from mysql import connector
  my_sql_connection = connector.connect(user='user', password='pass',
                                                host='hostname',
                                                database='db')
  mysql_cursor = my_sql_connection.cursor()
  
  statement = "Insert into table (col) values (1); Insert into table (col) values (2);"
  
  mysql_cursor.execute(statement, multi=True)
  my_sql_connection.commit()
  mysql_cursor.close()
  my_sql_connection.close()
  </code></pre>
  
  <p>After this code is called, there are no errors however no new rows show up in the table. </p>