RE: [PHP] Escaping nasty quotes
| From: | Jay Blanchard | Date: | Thu, 31 Jul 2003 18:57:37 +0000 |
| Subject: | RE: [PHP] Escaping nasty quotes | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-157791@lists.php.net to get a copy of this message | ||
[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 '' ";