if __name__ == '__main__': msql = ConnMysql('root', 'mysql', 'python2105') for data in datas: msql.executefun('insert into weibo value (default ,"%s","%s")'%(data[0],data[1])) # 添加语句 msql.save()
这样写就会出现:光标报错(ProgrammingError("Cursor closed")pymysql.err.ProgrammingErro)
解决方法:
if __name__ == '__main__': msql = ConnMysql('root', 'mysql', 'python2105') for data in datas: msql.executefun('insert into weibo value (default ,"%s","%s")'%(data[0],data[1])) # 添加语句 msql.save()