最新消息: 新版网站上线了!!!

python+pymysql错误AttributeError: 'Cursor' object has no attribute 'commit'

源码

conn = pymysql.Connect(host = '127.0.0.1', port = 3306, user = 'root', passwd = 'root', db = 'scrapy',charset = 'utf8')

cur = conn.cursor()

self.cur.execute('INSERT into kandian (title,content)values("1111","wwww")')

self.cur.commit()

执行提示错误AttributeError: 'Cursor' object has no attribute 'commit'

原因:提交的应该是连接而不是游标

错误位置self.cur.commit()

正确写法:self.conn.commit()


转载请注明:谷谷点程序 » python+pymysql错误AttributeError: 'Cursor' object has no attribute 'commit'