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
[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
[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
Hi Juan Pablo,
LOAD DATE INFILE requires the FILE privelege, and the MySQL
server process must have permissions to read the file in the
named directory. Most times one or both of these requirements
cannot be satisfied easily, particularly in a web environment.
You can get around both permissions
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
13 matches
Mail list logo
