title: TypeError: 'str' object is not callable
body: <p>I am trying to take the excel data which is the var 'y' which is numerical data and put it into my SQL column 'Close'.</p>
  
  <pre><code>import xlrd
  import MySQLdb
  
  #get excel data
  file_location = "C:/Users/.../.../...xls"
  workbook = xlrd.open_workbook(file_location)
  sheet = workbook.sheet_by_name("Sheet1.1")
  y = sheet.col_values(3, start_rowx=2, end_rowx=31)
  
  #open connection SQL
  db=MySQLdb.connect(host = "host",
                      user = "user",
                      passwd = "passwd",
                      db = "test")
  cursor = db.cursor()
  cursor.execute("""UPDATE uk SET Close.....""")
  
  db.commit()
  </code></pre>
  
  <p>However i am not sure what to write to insert it.</p>
  
  <pre><code>cursor.execute("""UPDATE uk SET Close = %s""", (y,))
  </code></pre>
  
  <p>Gives the error that:</p>
  
  <pre><code>OperationalError: (1241, 'Operand should contain 1 column(s)')
  </code></pre>
  
  <p>Thank you for any help or direction you can provide.</p>