sql="insert into test (company,position,address,salary,url,date)values (%s,%s,%s,%s,%s,%s)"
try:
self.cur.execute(sql,item['company'],item['position'],item['address'],item['salary'],item['url'],item['date'])
self.conn.commit()
except:
self.conn.rollback()
解决方法,后面所有的数据都需要用括号括起来
sql="insert into test (company,position,address,salary,url,date)values (%s,%s,%s,%s,%s,%s)"
try:
self.cur.execute(sql,(item['company'],item['position'],item['address'],item['salary'],item['url'],item['date']))
self.conn.commit()
except:
self.conn.rollback()
pymysql无法插入数据库以前是做PHP的刚接触python怎么也插入不了数据库 也没有报错误 源代码如下 sql="insert into test (company,position,address,salary,url,date)values (%s,%s,%s,%s,%s,%s)" try: self.cur.execute(sql,item['company...