Load Data Local Infile
| From: | Harlequin | Date: | Thu, 02 Sep 2004 09:18:32 +0000 |
| Subject: | Load Data Local Infile | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-195524@lists.php.net to get a copy of this message | ||
I am using the following command and it appears to execute but does not
actually load any data:
LOAD DATA LOCAL INFILE 'public_html/CSV/act-export.csv' INTO TABLE
MembersData
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';
Any ideas what I might be missing...?
The file exists, and I must have the path right or would get an error but
still no joy unfortunately...
--
-----------------------------
Michael Mason
Arras People
www.arraspeople.co.uk
-----------------------------