I have a tab delimeted file that I want to convert into a mysql table
Posted
by user320835
on Stack Overflow
See other posts from Stack Overflow
or by user320835
Published on 2010-04-19T23:08:10Z
Indexed on
2010/04/19
23:13 UTC
Read the original article
Hit count: 107
I have a tab delimeted file that I want to convert into a mysql table. there are 25 tab delimeted fields in the text file. I can get the values in when I construct the SQL statement word by word and get each value individually stated in the VALUES part but when I try to get the list as a whole it does not work. Here is the code. I couldn't figure it out. Any ideas?
lines=open(path, "r").readlines()
for line in lines[1:]:
linex=line.strip().split("\t")
linex.insert(0,'sometextindex')
try:
cursor.execute('INSERT INTO variants VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)',linex)
except:
print 'line number=',a,linex
© Stack Overflow or respective owner