title: MySQL data insertion to a newly added column
body: <p>I am new to MySQL. I have created a table and created 2 columns and inserted some elements. I created another column in same table. When I try to insert data in the new Column, it shows error like: <code>Not all parameters were used in the SQL statement</code></p>
  <p>I have tried the following:</p>
  <pre><code>for i in cur:
      print(i)
      age = int(input(&quot;age for &quot;+i[0]))
      query = 'INSERT INTO student (student_name,age) values (%s,%d);'
      val = (i[0],age)
      cur.execute(query,val)
      con.commit()
  
  
  student_name was already in the table.
  
  query = 'INSERT INTO student (student_name,age) values ({0},{1}) on duplicate key update student_name = {0}, age = {1};'.format(i[0], age)
  </code></pre>
  <p>Both show same error. Please help me to fix it.</p>