title: insert two values from an mysql table into another table using a python program
body: <p>I'm having a small problem with a Python program (below) that I'm writing. </p>
  
  <p>I want to insert two values from a MySQL table into another table from a Python program.</p>
  
  <p>The two fields are priority and product and I have selected them from the shop table and I want to insert them into the products table. </p>
  
  <p>Can anyone help? Thanks a lot. Marc.</p>
  
  <pre><code>import MySQLdb
  
  def checkOut():
      db = MySQLdb.connect(host='localhost', user = 'root', passwd = '$$', db = 'fillmyfridge')
      cursor = db.cursor(MySQLdb.cursors.DictCursor)
      user_input = raw_input('please enter the product barcode that you are taking out of the fridge: \n')
      cursor.execute('update shops set instock=0, howmanytoorder = howmanytoorder + 1  where barcode = %s', (user_input))
      db.commit()
      cursor.execute('select product, priority from shop where barcode = %s', (user_input))
      rows = cursor.fetchall()
      cursor.execute('insert into products(product, barcode, priority) values (%s, %s)', (rows["product"], user_input, rows["priority"]))
      db.commit()
      print 'the following product has been removed from the fridge and needs to be ordered'
  </code></pre>