title: Python update query in mariadb
body: <p>I am trying to update my mariadb table via python code .While compile the query nothing happen in my database. please check below code and let me know where i made mistake in update function</p>
  <pre><code>import mariadb
  
  connection= mariadb.connect(user=&quot;user1&quot;, database=&quot;db1&quot;, host=&quot;ippp&quot; ,password=&quot;pass&quot;)
  
  cursor= connection.cursor()
  
  cursor.execute(&quot;UPDATE product_options_combinations SET quantity=5944 WHERE item_code ='31628'&quot;)
  
  
  cursor.close()
  connection.close()
  </code></pre>