title: Not saving data mysql-connector-python
body: <p>I'm trying to save data inside MySQL from python script.<br>
  I have imported <code>mysql-connector-python</code>, and I tried to save some data using it, like this:</p>
  <pre><code>import mysql.connector
  
  connection = mysql.connector.connect(user=&quot;root&quot;,database=&quot;test_db&quot;)
  cursor = cnx.connection()
  
  cursor.execute(&quot;INSERT INTO category (category_name) VALUES ('test')&quot;)
  print(cursor.fetchall())
  </code></pre>
  <p>But I got nothing printed out except <code>[]</code>. I checked if the data was successfully saved t o the database, but nothing was saved. So I tried <code>INSERT INTO category (category_name) VALUES ('test')</code> directly inside my database, and it worked.<br>
  There's one thing caught my sight is that after I ran <code>INSERT INTO category (category_name) VALUES ('test')</code> my database and successfully created the data, the data's primary key was set to <code>2</code>. The database is newly created one.</p>