我的文本文件如下所示:10May2013 3.1 http://ncbi.org p.sojae_aafeatureimp p.sojae_aafeatureimp10May2013 3.2 http://ncbi.org p.sojae_aasequenceimp p.sojae_aasequenceimp10May2013 3.3 http://ncbi.org p.sojae_blatalignment p.sojae_blatalignment如何解析這些單獨的行并將其插入到數據庫中?數據庫結構:(日期,版本,URL,名稱,描述)我必須使用Python將文本文件中的值插入mysql。到目前為止,我的腳本是這樣的:import MySQLdb, csv, syswith open('externaldatabase.txt') as textfile: csvreader = csv.reader(textfile) csvdata = [] for row in csvreader: csvdata.append(row)conn = MySQLdb.connect (host = "localhost",user = "username", passwd = "password",db = "database_name")c = conn.cursor()for row in csvdata:# Insert a row of datac.execute("INSERT INTO externaldatabase (release_date, version, download_url, name, description) VALUES ('%s', '%s', '%s', '%s', '%s')" % (row))conn.commit()c.close()但它讓我出錯:Traceback (most recent call last):File "csv1.py", line 16, in <module>c.execute("INSERT INTO externaldatabase (release_date, version, download_url, name, description) VALUES ('%s', '%s', '%s', '%s', '%s')" % (row))TypeError: not enough arguments for format string
添加回答
舉報
0/150
提交
取消