'LOAD DATA INFILE' clarification, path for the file
Posted: Thu Nov 12, 2009 11:09 pm
Hello,
Just trying to learn how this statement works.
I use a file on my machine and want to load into a db on my machine as well.
In the php I put the path to the file and the error is 'Query was empty'.
I load the file using phpadmin and no error and in the generated php code the path is
Why's that ? I'm puzzled.
How shall I make it work ?
Thank you
Just trying to learn how this statement works.
I use a file on my machine and want to load into a db on my machine as well.
In the php I put the path to the file
Code: Select all
'c:\wamp\www\tests\file.txt'I load the file using phpadmin and no error and in the generated php code the path is
Code: Select all
'c:/wamp/tmp\\php11.tmp'How shall I make it work ?
Thank you