Posted by Wessley Roche on 07/01/05 12:55

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
···

• Next in forum: Re: [PHP] PHP Magazine
• Prev in forum: Re: [PHP] postgres - mysql last_inserted_id
• Thread view: MySQL error

[Reply to this message]