MySQLdb插入数据时占位符问题

yufei_sh

回复 10# 106033177

你好，这个问题的原因我想到了，可是却解决不了，具体的情况如下：
Datalist = []  #Datalist 的值是读文件提取出的一个列表Print输出的格式如下：

>>> print Datalist
['2012', '07-1', '04:04:47', 'qmgr[32541]', '46A761060131', 'aaa@163.com', '2395', 'bb@sina.com', 'deferred']
['2012', '07-1', '04:04:47', 'qmgr[32541]', '46A761060131', 'aaa@163.com', '2395', 'bb@sina.com', 'deferred']
['2012', '07-1', '04:04:47', 'qmgr[32541]', '46A761060131', 'aaa@163.com', '2395', 'bb@sina.com', 'deferred']
['2012', '07-1', '04:04:47', 'qmgr[32541]', '46A761060131', 'aaa@163.com', '2395', 'bb@sina.com', 'deferred']
['2012', '07-1', '04:04:47', 'qmgr[32541]', '46A761060131', 'aaa@163.com', '2395', 'bb@sina.com', 'deferred']
['2012', '07-1', '04:04:47', 'qmgr[32541]', '46A761060131', 'aaa@163.com', '2395', 'bb@sina.com', 'deferred']
['2012', '07-1', '04:04:47', 'qmgr[32541]', '46A761060131', 'aaa@163.com', '2395', 'bb@sina.com', 'deferred']
['2012', '07-1', '04:04:47', 'qmgr[32541]', '46A761060131', 'aaa@163.com', '2395', 'bb@sina.com', 'deferred']
['2012', '07-1', '04:04:47', 'qmgr[32541]', '46A761060131', 'aaa@163.com', '2395', 'bb@sina.com', 'deferred']
['2012', '07-1', '04:07:06', 'qmgr[32541]', 'C1A0A1060137', 'aaa@163.com', '10668', 'bb@sina.com', 'bounced']
['2012', '07-1', '04:07:06', 'qmgr[32541]', 'C1A0A1060137', 'aaa@163.com', '10668', 'bb@sina.com', 'bounced']
['2012', '07-1', '04:07:06', 'qmgr[32541]', 'C1A0A1060137', 'aaa@163.com', '10668', 'bb@sina.com', 'bounced']
['2012', '07-1', '04:07:06', 'qmgr[32541]', 'C1A0A1060137', 'aaa@163.com', '10668', 'bb@sina.com', 'bounced']

这样作为下面语句会出错
c.executemany(
      """INSERT INTO breakfast (a,b,c,d,e,f,g,h,i)
      VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s)""",Datalist)

TypeError: not all arguments converted during string formatting

106033177

回复 11# yufei_sh
按照你写这个插入语句executemany应该只是循环调用execute。不知道为何会execute可以 而executemany不行。