Wessley Roche wrote:
I'm having a problem with the following code:
$sql = "LOAD DATA LOCAL INFILE '/path/to/file.txt' INTO TABLE `mytable`
FIELDS TERMINATED BY '\t' ESCAPED BY '\' LINES TERMINATED BY '\n'";
mysql_query($sql) or die('<br><br>'.mysql_error());
I get this MySQL error:
You have an error in your SQL syntax. Check the manual that corresponds
to your MySQL server version for the right syntax to use near ''' at
line 2
You're on the wrong list. You want the MySQL mailing list.
Just as a pointer, you probably want "ESCAPED BY '\''" rather than
"ESCAPED BY '\'" (added a ' to close the first quote, as the second one
is escaped.
Jasper
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
