Re: load data infile

[Randy Clamons]

According to the reference manual, "The filename must be given as a literal string", so, no, it can't be done in a stored procedure unless the filename is always the same. That doesn't seem likely.

In your Perl script, assign the input file name to a variable, then have Perl interpolate that string when you submit the command.

my $filename = 'file1.ext';
my $sql = "LOAD DATA INFILE '$filename' ....";