插入数据库本来是一个很简单的问题:
sql="insert into p1(url) values (%s)"
list=(item['url'])
try:
cur.execute(sql,list)
except Exception,e:
print('Insert error',e)
con.rollback()
else:
con.commit()
cur.close()
sql="insert into p1(url) values (%s)"
list=(item['url'])
try:
cur.execute(sql,list)
except Exception,e:
print('Insert error',e)
con.rollback()
else:
con.commit()
cur.close()
con.close()
但是,居然报错:
('Insert error', TypeError('not all arguments converted during string formatting',))
啊,找了半天错误,最后发现,竟然是
list=(item['url'])
只有是list=[item['url']]才可以,很奇怪
我用的是:python 2.7.12 ,mysql :5.5.40 MySQL Community Server (GPL)