title: error "column count doesnt match value count at row 1" while inserting new values into table
body: <p>I'm trying to add new values to the MySQL database table, but there is always an error. I am new to python programming so I don't really know how all of this works. the photo of the error is below.</p>
  <pre><code>def add_new():
      eq_name = t1.get()
      total2 = t2.get()
      query = &quot;INSERT INTO Equipment(equipmentID, name, available, borrowed,  total) VALUES(NULL, %s, %s, %s, %s, NOW())&quot;
      cursor.execute(query, (eq_name, total2, 0, total2 ))
      clear()
  </code></pre>
  <p><img src="https://i.stack.imgur.com/qOK2I.png" alt="enter image description here" /></p>