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"
我需要通过row, row, row
以使其正确,但是不能这样做。怎么修?
编辑:打印行给出:
['6630\tCarmen Rocche\[email protected]\t\t\t\t\t']
['6631\tSuhasini\[email protected]\t\t\t\t\t']
['6632\tAmarjeet \[email protected]\t\t\t\t\t']
['6633\tFazali Hadi\[email protected]\t\t\t\t\t']
['6634\tVishaka Samarakone\[email protected]\t\t\t\t\t']
['6635\tLoemongga\[email protected]\t\t\t\t\t']
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)
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句