Python循环插入数据库失败是何原因，python何原因,def insert_i

Python循环插入数据库失败是何原因，python何原因,def insert_i

def insert_into_bet(data):    len_team_data = int(len(data)/7)    conn=mdb.connect(host='localhost',user='root',passwd='oracle',db='betdb',port=3306)    cur = conn.cursor()    sql = "insert into bet(id,lea,gmd,hos,gue,hos_sco,gue_sco) values(%s,%s,%s,%s,%s,%s,%s)"    for l in range(len_team_data):        for item in data[7*l:7*l+1]:            cur.executemany(sql,data[7*l:7*l+7])            l+=1    cur.close()    conn.commit()    conn.close()if __name__=='__main__':#     download_live_urls()    now = datetime.datetime.now()    now_date = now.strftime('%Y-%m-%d')    pages_path = '/root/bet/teamUrls/%s' % now_date    for page in os.listdir(pages_path):        page_path = '/root/bet/teamUrls/%s/%s' % (now_date,page)        #问题出在这里！！！        insert_into_bet(from_page_to_data(page_path))

我尝试取消main里面的for循环，然后执行insert_into_bet这个，是可以插入数据库的，但是一旦加入for循环以后，就无法插入数据库了，不知道什么原因，求指点~

forexecutemany

def insert_into_bet(data):len_team_data = int(len(data)/7)conn=mdb.connect(host='localhost',user='root',passwd='oracle',db='betdb',port=3306)cur = conn.cursor()sql = "insert into bet(id,lea,gmd,hos,gue,hos_sco,gue_sco) values(%s,%s,%s,%s,%s,%s,%s)"for l in range(len_team_data):    for item in data[7*l:7*l+1]:        cur.executemany(sql,data[7*l:7*l+7])        l+=1cur.close()conn.commit()conn.close()

编橙之家文章，