MySQL Forums
Forum List  »  Perl

Re: Using load data for multiple files
Posted by: Ravishankar Arivazhagan
Date: February 25, 2010 05:12PM

Hi,

Thank you for the reply.
I am trying to load 516 different files and each file has an average of 90line( which would be 90 rows in the table).

"Unable to locate record..."

What the sql query does is :

as mentioned earler the file name is xyz_kjk.general.
so here I have xyz as primary key to uniquely identify this file in the table. I have given it a group number(primary key) in another table. So the query fetches this file, looks up for file name in another table, fetches its number and inserts the number along with file contents into a table.

Query used:
load data local infile '$file' INTO TABLE $tablename1 fields terminated by ',' ignore 1 lines (model_number, pocket_number, go_molecularfunction, probability) set gno=$results[0];

Ignore the variables.This query is inside a foreach perl loop.
Hope this helps. I will post the error log sometime soon.

Thanks again

Options: ReplyQuote


Subject
Written By
Posted
Re: Using load data for multiple files
February 25, 2010 05:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.