python报错原因

Question

curoser = conn.cursor()
sql = "insert into school values(%s,%s,%s,%s)"
curoser.execute(sql, list)
conn.commit()
curoser.close()
conn.close()

Answer 1

代码错误提示了有的参数没转成string，要么就是你sql元组的顺序不对，要么元祖数量和类型不匹配