Hello.
Looks like LOAD DATA INFILE supports only string constants in
its syntax. I think it has sense, because security risk grows,
when we can substitute variables in the file name.
Scott Klarenbach <[EMAIL PROTECTED]> wrote:
> I can't seem to make the Load Data statement work inside
I can't seem to make the Load Data statement work inside of a stored procedure.
ie
LOAD DATA LOCAL INFILE "file.txt" INTO my_table
this works fine in PHP, but when I use it in a procedure, and pass in
the file name as a parameter, it won't compile.
LOAD DATA LOCAL INFILE fileParameter INTO my_
