Re: [PHP-DB] [Import text file]

2003-02-13 Thread Jason Wong
On Friday 14 February 2003 00:29, karthikeyan.balasubramanian wrote: > This LIST need some change :). Your email client needs changing :) > Generally we just say reply and give our suggestions. This works in other > list. The 'other' list is broken. > This one goes only to the person who posed

Re: [PHP-DB] [Import text file]

2003-02-13 Thread karthikeyan.balasubramanian
MAIL PROTECTED]] > Sent: Thursday, February 13, 2003 9:03 AM > To: Hutchins, Richard > Subject: Re: [PHP-DB] [Import text file] > > > try using something like this > > C:\\WINDOWS\\TEMP\\PHPC255.TMP > > Hope this works. > > Have a great day. > - Or

RE: [PHP-DB] [Import text file]

2003-02-13 Thread Hutchins, Richard
A quick trip through the MySQL manual hints that you may have to use forward slashes in your path on a windows system. So... LOAD DATA LOCAL INFILE 'C:/WINDOWS/TEMP/phpC255.TMP' INTO TABLE abonnes FIELDS TERMINATED BY ';' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' (dp_indpri,dp_nom,dp_ville) .