format表达式报错

format表达式报错

def insert_4_data(id,name,win,fu,jifen,shenglv,zhu,ke,link):
    sql = "insert into teamwin(id,name,win,fu,jifen,shenglv,zhu,ke,link) VALUES ('%d','%s','%s','%s','%s','%s','%s','%s','%s','%s')"
    value=(id,name,win,fu,jifen,shenglv,zhu,ke,link)
    print(sql % value)
    res = query(sql % value)
    return res

我想把下面的内容存入数据库中

浙江稠州金租,35,7,77,83.3%,16,19https://www.cbaleague.com/data/#/teamMain?teamId=29140

广东东莞大益,33,9,74,78.6%,18,15https://www.cbaleague.com/data/#/teamMain?teamId=29124

辽宁本钢,32,10,74,76.2%,18,14https://www.cbaleague.com/data/#/teamMain?teamId=29129

深圳马可波罗,28,14,70,66.7%,14,14https://www.cbaleague.com/data/#/teamMain?teamId=29131

上海久事,26,16,68,61.9%,14,12https://www.cbaleague.com/data/#/teamMain?teamId=29125

北京首钢,26,16,68,61.9%,12,14https://www.cbaleague.com/data/#/teamMain?teamId=29115

浙江东阳光,25,17,67,59.5%,16,9https://www.cbaleague.com/data/#/teamMain?teamId=29128

山东高速,23,19,65,54.8%,16,7https://www.cbaleague.com/data/#/teamMain?teamId=29130

广州龙狮,22,20,64,52.4%,11,11https://www.cbaleague.com/data/#/teamMain?teamId=29139

山西汾酒股份,21,21,63,50.0%,14,7https://www.cbaleague.com/data/#/teamMain?teamId=29132

九台农商银行,20,22,62,47.6%,10,10https://www.cbaleague.com/data/#/teamMain?teamId=29137

苏州肯帝亚,19,23,61,45.2%,9,10https://www.cbaleague.com/data/#/teamMain?teamId=29118

青岛国信水产,18,24,60,42.9%,12,6https://www.cbaleague.com/data/#/teamMain?teamId=29135

南京同曦宙光,17,25,58,40.5%,9,8https://www.cbaleague.com/data/#/teamMain?teamId=29133

北京控股,16,26,58,38.1%,10,6https://www.cbaleague.com/data/#/teamMain?teamId=29136

福建浔兴股份,13,29,55,31.0%,6,7https://www.cbaleague.com/data/#/teamMain?teamId=29134

新疆伊力王酒,20,22,55,47.6%,12,8https://www.cbaleague.com/data/#/teamMain?teamId=29117

四川金荣实业,12,30,54,28.6%,7,5https://www.cbaleague.com/data/#/teamMain?teamId=29127

天津先行者,10,32,52,23.8%,7,3https://www.cbaleague.com/data/#/teamMain?teamId=29138

宁波町渥,4,38,46,9.5%,4,0https://www.cbaleague.com/data/#/teamMain?teamId=100074683

球队数据爬取结束

结果报错

Traceback (most recent call last):
  File "C:\Users\75930\Desktop\basketball\spider.py", line 298, in <module>
    team_data()
  File "C:\Users\75930\Desktop\basketball\spider.py", line 288, in team_data
    insert_4_data(id, names[i], wins[i], loses[i], jifens[i], shenglvs[i] ,zhuwins[i], kewins[i],line)
  File "C:\Users\75930\Desktop\basketball\utils.py", line 68, in insert_4_data
    print(sql % value)
TypeError: not enough arguments for format string

not enough arguments for format string 这个报错是说参数数量和格式串里面的占位符数量没对上。print()是这样传，你先将SQL里面参数，和value对应的值，都减少试试，从第一个参数开始，看看是那个参数有问题