Re: Load Data infile
| From: | Juan Pablo Herrera | Date: | Thu, 13 May 2004 21:49:23 +0000 |
| Subject: | Re: Load Data infile | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-186164@lists.php.net to get a copy of this message | ||
> [snip]
> I need do load data infile in mysql:
> $query_string2 = "LOAD DATA INFILE '/var/www/xls/test' REPLACE INTO
> TABLE
>
test FIELDS TERMINATED BY ',' ENCLOSED BY
> '\"' ESCAPED BY '\\' LINES
> TERMINATED BY '\n'";$query_db_string2 = mysql_query($query_string2);
> But not realize nothing with execution the script.
> [/snip]
>
> have you checked mysql_error() ?
yes,
You have an error in your SQL syntax near ''' at line 2
but i change '\"' and not work.
Thank you,
Juan Pablo