insert_into

insert_into.py

del fList[0]

rows = ''

for i in range(len(fList)-1):
     rows += "('{}','{}','{}','{}','{}','{}','{}','{}','{}','{}')"\
         .format(fList[i][0], fList[i][1], fList[i][2], fList[i][3], fList[i][4],
                 fList[i][5], fList[i][6], fList[i][7], fList[i][8], fList[i][9])

     if i != len(fList)-2:
         rows += ','

print(rows)
queryInsert = "INSERT INTO FOOTBALL VALUES" + rows

cursor.execute(queryInsert)
mydb.commit()