RE: [PHP] Escaping nasty quotes
| From: | Roy W | Date: | Thu, 31 Jul 2003 18:58:31 +0000 |
| Subject: | RE: [PHP] Escaping nasty quotes | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-157792@lists.php.net to get a copy of this message | ||
Unfortunately, they are indeed enclosed by double quotes
Roy
-----Original Message-----
From: Jay Blanchard [mailto:jay.blanchard@niicommunications.com]
Sent: Thursday, July 31, 2003 12:58 PM
To: Roy W; php-general@lists.php.net
Subject: RE: [PHP] Escaping nasty quotes
[snip]
Sorry...Because of the double quote near the ENCLOSED BY .. It delivers a
PARSE ERROR
$query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable FIELDS
TERMINATED BY ',' ENCLOSED BY '"' "; [/snip]
Are the fields enclosed by a quote? If not...
$query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable FIELDS
TERMINATED BY ',' ENCLOSED BY '' ";