load data infile

[liping yi]

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?

Thanks!