MySQL error
| From: | Wessley Roche | Date: | Fri, 01 Jul 2005 09:55:16 +0000 |
| Subject: | MySQL error | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-217962@lists.php.net to get a copy of this message | ||
Hi,
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
What am I doing wrong?
Doing this from phpMyAdmin works fine.
Thanks,
wes
···
Wessley Roche · Icon Designer · wessley@iconizer.com · www.iconizer.com
···