MySQL Forums
Forum List  »  Perl

load data infile
Posted by: liping yi
Date: July 20, 2010 01:46PM

Hi, all

Thanks in advance for your help!

My perl script needs to load multiple csv files into a table (say Test),let's say the file has 2 columns: name, job. and the table has one more column,ID (PK). Do I need a temp table to hold the incoming data first, then insert into the Test table? if so, how can I do that in perl or mysql sript( as a function ? because stored procedure can not work, is that right?), Or other suggestions?


Options: ReplyQuote

Written By
load data infile
July 20, 2010 01:46PM
July 20, 2010 02:15PM
July 20, 2010 02:25PM
July 20, 2010 03:39PM
August 30, 2010 01:26PM

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.