Re: perl DBI LOAD DATA INFILE

To import the datafile, first upload it to your home directory, so that the file is now located at /importfile.csv on our local system. Then you type the following SQL at the mysql prompt:

    LOAD DATA LOCAL INFILE '/importfile.csv'
    INTO TABLE test_table
    FIELDS TERMINATED BY ','
    LINES TERMINATED BY '\n'
    (field1, filed2, field3);
[download]

Comment on Re: perl DBI LOAD DATA INFILE Download Code

Replies are listed 'Best First'.
Re^2: perl DBI LOAD DATA INFILE by nickd (Novice) on Oct 14, 2013 at 12:12 UTC
Hi, I will need to upload multiple files daily hence am trying to script it using perl. I cannot use manual upload at the command prompt.	[reply]