python - 将 csv 导入 MySQL 数据库时格式字符串参数不足

Question

Full Traceback:
 File "./csvimportdb.py", line 12, in <module>
    cursor.execute('''INSERT INTO newsletter_subscriber(id, name, email ) VALUES("%s", "%s", "%s")''', row)
  File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 159, in execute
    query = query % db.literal(args)
TypeError: not enough arguments for format string

我的代码:

#!/usr/bin/python

import csv
import MySQLdb

mydb = MySQLdb.connect(host='localhost', user='english', passwd='english', db='english_mez')
cursor = mydb.cursor()

csv_data = csv.reader(file('final.csv'))
for row in csv_data:

    cursor.execute('INSERT INTO newsletter_subscriber(id, name, email )' 'VALUES("%s", "%s", "%s")', row[0], row[1], row[2])
#close the connection to the database.
mydb.commit()
cursor.close()
print "Done"

我需要传递行，行，行才能使其正确，但无法做到这一点。如何修复？

编辑:打印行给出:

['6630\tCarmen Rocche\trocchecarmen@gmail.com\t\t\t\t\t']
['6631\tSuhasini\tkkalva14@hotmail.com\t\t\t\t\t']
['6632\tAmarjeet \tsweetylamba@gmail.com\t\t\t\t\t']
['6633\tFazali Hadi\tshewasb@yahoo.com\t\t\t\t\t']
['6634\tVishaka Samarakone\tshirashi.vishaka@gmail.com\t\t\t\t\t']
['6635\tLoemongga\tloemongga@yahoo.com\t\t\t\t\t']

Answer 1

for row in csv_data:
    data=row[0].split('\t')
    if len(data) < 4: continue
    query="""insert into newsletter_subscriber (id, name, email) values 
      (%d, '%s', '%s')""" %(int(data[0]), data[1], data[2])
    cursor.execute(query)