scrapy爬虫连接数据库问题

Question

conn.execute("""
        insert into bookinfo(title,author,price)
      values(%s,%s,%s)
""",(item['title'],item['author'],item['price']))

scrapy爬虫，连接数据库，但是报错
_mysql_exceptions.OperationalError: (1241, 'Operand should contain 1 column(s)')

Answer 1

字符串的列要打引号， values('%s','%s','%s')

Answer 2

conn.execute("""

    insert into bookinfo(title,author,price)
  values(%s,%s,%s)

""" % (item['title'],item['author'],item['price']))