While I think this is primarily a mysql syntax problem I have asked on the
mysql forum but not got a reply. I am trying using php to set up a system for
loading a new data base using the Load Data Infile statement. I could not get
it to work properly with php so I thought I would try some comma
Jason Wong wrote:
On Thursday 02 September 2004 17:18, Harlequin wrote:
I am using the following command and it appears to execute but does not
actually load any data:
LOAD DATA LOCAL INFILE 'public_html/CSV/act-export.csv' INTO TABLE
MembersData
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
On Thursday 02 September 2004 17:18, Harlequin wrote:
> I am using the following command and it appears to execute but does not
> actually load any data:
>
> LOAD DATA LOCAL INFILE 'public_html/CSV/act-export.csv' INTO TABLE
> MembersData
> FIELDS TERMINATED BY ','
> LINES TERMINATED BY '\n';
Is t
[snip]
I am using the following command and it appears to execute but does not
actually load any data:
LOAD DATA LOCAL INFILE 'public_html/CSV/act-export.csv' INTO TABLE
MembersData
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';
Any ideas what I might be missing...?
The file exists, and I
I am using the following command and it appears to execute but does not
actually load any data:
LOAD DATA LOCAL INFILE 'public_html/CSV/act-export.csv' INTO TABLE
MembersData
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';
Any ideas what I might be missing...?
The file exists, and I must ha
[snip]
i need do two querys in one.
First query is a load data and the second query is insert into.
My idea is to concatenate with "and", but i'not know.
Is it possible?
[/snip]
a. It is possible. http://catb.org/~esr/faqs/smart-questions.html
2. This is a PHP list, not a SQL list.
III. HTH!
INSE
Hi!
i need do two querys in one.
First query is a load data and the second query is insert into.
My idea is to concatenate with "and", but i'not know.
Is it possible?
Regards,
Juan
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[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
>-Original Message-
>From: Juan Pablo Herrera [mailto:[EMAIL PROTECTED]
>Sent: Thursday, June 10, 2004 4:15 PM
>To: [EMAIL PROTECTED]
>Subject: [PHP] Load Data
>
>
>Hello!
>I need a problem with mysql "Load Data". PHP say: "Access denied for user:
Hello!
I need a problem with mysql "Load Data". PHP say: "Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES)", but my user and password is
correct.The sql query is:
$query_string2 = "LOAD DATA INFILE
'/usr/local/psa/home/vhosts/allaria.com.ar/httpdocs/XLS/precios' REPLACE
INTO TABLE
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
22 matches
Mail list logo
