mysql database

Question

biomed 0 Newbie Poster

13 Years Ago

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?

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

python

Edited 13 Years Ago by biomed because: n/a

1 Contributor
1 Reply
83 Views
1 Day Discussion Span
Latest Post 13 Years Ago Latest Post by biomed

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

biomed 0 Newbie Poster · Answer 1 · 2010-04-21T01:03:16+00:00

The answer came from stackoverflow site. I used LOAD DATA LOCAL INFILE instead and it solved my problem.

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?
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