[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
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 and t
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
Hi!
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 s
"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
Off topic but I hope somebody can help.
Using MS Win98 / mySQL.
I'm trying to use LOAD DATA INFILE and coming up empty.
My text file is named:
test.txt
..
and is stored in C:\TextFiles
on the command line I type:
..
mysql> LOAD
MAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Tuesday, May 14, 2002 6:53 PM
Subject: [PHP] Load data infile
> Hello,
>
> Is it possible to do the load data info mysql command via PHP
>
>
> I get an access denied erro
[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
Hello,
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.
Thanks
Randy
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hello everyone,
I posted this message to the mysql mailing list and didn't get a response.
I know a lot of people here are good with SQL. So, here's my e-mail:
Hello,
I've been struggling with this all night. Can someone give me a push in the
right direction? I
have a csv file named Sheet1.t
13 matches
Mail list logo