Re: MySQL error
| From: | Jasper Bryant-Greene | Date: | Fri, 01 Jul 2005 10:22:28 +0000 |
| Subject: | Re: MySQL error | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-217963@lists.php.net to get a copy of this message | ||
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