python批量插入mysql数据

hucuibai

1. import os
   
2. import MySQLdb
   
3. 
   
4. def onlineinsert(val,database):
   
5.     try:
   
6.         conn=MySQLdb.connect(host='localhost',user='root',passwd='123456',db=database)
   
7.     except:
   
8.         pass
   
9.    
   
10.     cursor=conn.cursor()
    
11.     sql='insert ignore into onlinetimerecord(PlayerID,AccountID,ClientType,OnlineTime,OfflineTime,LoginIP,DiamondLogin,DiamondLogoff) values(%s,%s,%s,%s,%s,%s,%s,%s)'
    
12.     print sql
    
13.     cursor.execute(sql,val)
    
14. 
    
15. if __name__=='__main__':
    
16.     val=[(4295188411, 86364, 3, "2011-05-29 23:59:29", "2011-05-30 00:00:22", "115.225.23.218", 0, 0),(4295695241, 3371381, 3, "2011-05-29 22:18:50", "2011-05-30 00:01:11", "183.6.149.50", 0, 0)]
    
17.     onlineinsert(val,'jyw-gamerecord-1003')
    
18. 
    
19. 
    
20. 
    

复制代码

报错信息：
Traceback (most recent call last):
  File "F:\out.py", line 17, in <module>
  onlineinsert(val,'jyw-gamerecord-1003')
  File "F:\out.py", line 13, in onlineinsert
  cursor.execute(sql,val)
  File "C:\Python27\lib\site-packages\MySQLdb\cursors.py", line 159, in execute
  query = query % db.literal(args)
TypeError: not enough arguments for format string

本人是新手，高人指点！！

flying_away

应该是这个函数吧
cursor.executemany