pymysql TypeError: not enough arguments for format string

  mysql, question

The following error occurred when I was writing Python pymysql to the database:

C:\Python27\python.exe E:/pythonbao/bao1/.idea/20160718.py
 Traceback (most recent call last):
 File "E:/pythonbao/bao1/.idea/20160718.py", line 35, in <module>
 "percentage s, percentage s, percentage s, percentage s, percentage s, percentage s, percentage s, percentage s, percentage s)", value)
 File "C:\Python27\lib\site-packages\pymysql\cursors.py", line 159, in execute
 query = self.mogrify(query, args)
 File "C:\Python27\lib\site-packages\pymysql\cursors.py", line 138, in mogrify
 Query = query percentage self._escape_args(args, conn)
 TypeError: not enough arguments for format string

After Baidu changed “percentage s” to “percentage s”, it was useless.
The following is the code

# -*- coding: utf-8 -*-
 import urllib2
 import pymysql
 import time
 from bs4 import BeautifulSoup
 
 Today = time.strftime ('Percent Y- Percent m- Percent d',time.localtime(time.time ())
 
 loginHeaders = {
 'Host':'www.czce.com.cn',
 'User-Agent':'Mozilla/5.0 (Windows NT 6.1;   Win64;  x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.106 Safari/537.36',
 'Referer':'http://www.czce.com.cn/portal/jysj/mrhq/A091101index_1.htm',
 'Content-Type':'text/html',
 'Connection':'keep-alive'
 bracket
 url='http://www.czce.com.cn/portal/DFSStaticFiles/Future/2016/20160804/FutureDataDailyOI.htm'
 request = urllib2.Request(url, headers=loginHeaders)
 opener = urllib2.build_opener()
 response = opener.open(request)
 content = response.read().decode('gbk').replace("</tr>","").replace("<tr>","")
 soup = BeautifulSoup(content,'lxml').findAll(id="senfe")[0]
 table = soup.text.split("\n")
 conn = pymysql.connect(host="192.168.1.98",user="root",passwd="root",db="test",charset='utf8')
 cur = conn.cursor()
 value = []
 for i in range(0,8):
 Value.append((today,table[16+14*i],table[17+14*i],table[18+14*i],table[19+14*i],
 Table[20+14*i],table[21+14*i],table[22+14*i],table[23+14*i],
 Table[24+14*i],table[25+14*i],table[26+14*i],table[27+14*i],table[28+14*i],table[29+14*i]))
 cur.execute("INSERT INTO zhujiagewang"
 "(collecttime,pinzhongyuefen,zuojiesuan,jinkaipan,zuigaojia,zuidijai,"
 "jinshoupan,jinjiesuan,zhangdie1,zhangdie2,chengjiaoliang,kongpanliang,"
 "zengjianliang,chengjiaoe,jiaogejiesuanjia) "
 "VALUES (percentage s, percentage s, percentage s, percentage s, percentage s, percentage s, percentage s, percentage s, percentage s, percentage s, percentage s."
 "percentage s, percentage s, percentage s, percentage s, percentage s, percentage s, percentage s, percentage s, percentage s)", value)
 conn.commit()
 cur.close()
 conn.close()

Database data:
clipboard.png

for i in range(0,8):
 (today, table [16+14*i],table[17+14*i],table[18+14*i],table[19+14*i],
 Table[20+14*i],table[21+14*i],table[22+14*i],table[23+14*i],
 Table[24+14*i],table[25+14*i],table[26+14*i],table[27+14*i],table[28+14*i],table[29+14*i]))
 cur.execute("INSERT INTO zhujiagewang"
 "(collecttime,pinzhongyuefen,zuojiesuan,jinkaipan,zuigaojia,zuidijai,"
 "jinshoupan,jinjiesuan,zhangdie1,zhangdie2,chengjiaoliang,kongpanliang,"
 "zengjianliang,chengjiaoe,jiaogejiesuanjia) "
 "VALUES" plus
 ,'. join([ "(percent s)" percent','. join([' percent s']*15)] * 8), value)