FW: I need to use the Load Data command to load the contents ofa text file into a table.

Really the question is will the following work: LOAD DATA INFILE 'home/domain name/www/subdirectory/data.txt' INTO TABLE data FIELDS ENCLOSED BY '"' TERMINATED BY ',' LINES TERMINATED BY ';'; -Original Message- From: Hamilton, Jay Se

I need to use the Load Data command to load the contents of ate xt file into a table.

The problem is the text file resides on a server that holds the website pages. I am new to UNIX. How do I setup the LOAD DATA INFILE command to specify the text file if it is loaded on another server? This is what I have: LOAD DATA INFILE 'data.txt' INTO TABLE data FIELDS ENCLOSED BY '"' TER