[snip]
I have a tab delimited file I am trying to load in my database using:
LOAD DATA INFILE '/users/dbs/sites/phpmyadmin/gus/exptab.txt' INTO TABLE
datable;
But all it will load is the first record and I have about 2000 records.
There are 20 columns of data in my 'exptab.txt' file I am loading
Juan Pablo Herrera wrote:
[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 realiz
> [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 wit
[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 th
"Marco Tabini" <[EMAIL PROTECTED]> wrote in message:
> I'm not sure how MySQL works under Windows, but you should either use
> double backslashes (\\) instead of single backslashes or use forward
> slashes (/) instead. MySQL is trying to escape your string.
>
> Cheers,
> Marco
I'm not sure how MySQL works under Windows, but you should either use
double backslashes (\\) instead of single backslashes or use forward
slashes (/) instead. MySQL is trying to escape your string.
Cheers,
Marco
--
php|architect - The Magazine for PHP Professionals
The monthly mag
You may want to check permissions within your database. The web server user
may not have permissions to perform this action.
/dkm
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Philip Hallstrom" <[EMAIL PROTECTED]>
Cc: "Peter J. Schoenster" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
[snip]
Is it possible to do the load data info mysql command via PHP
I get an access denied error from mysql when i try to do that.
[/snip]
Are the permissions granted properly for the PHP user in the connection
statement?
Jay
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe
8 matches
Mail list logo