in reply to Re: Import file into MySQL table
in thread Import file into MySQL table
Hi,
I'm working on loading the data into a table. I'm receiving an error message that the text file cannot be located.
Here's the exact statement I'm typing in that calls in the text file.
mysql> LOAD DATA LOCAL INFILE 'C:\\Helen\\file.csv' INTO TABLE test
The rest of the command is the same as you gave me. I've read through the MySQL book on how to read a local file and I'm not sure what's happening.
Any ideas?
Thanks.