Me thinks you need to have file privileges. See
http://www.mysql.com/doc/P/r/Privileges_provided.html
-Original Message-
From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]]
the current problem at hand of getting the :
error:Access denied for user: 'mjimm@localhost' (Using
password: YES)
P 4L4
(403) 781-4948
-Original Message-
From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 10:35 AM
To: Darren Gamble
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP] Re-Importing .CSV file into Database
Hi Darren,
Actually your code worked, those errors did go wa
data correctness
!
>
> Valentin Petruchek (aki Zliy Pes)
> *** Cut the beginning ***
> http://zliypes.com.ua
> mailto:[EMAIL PROTECTED]
> - Original Message -
> From: "Thomas Edison Jr." <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: <[EMA
; - Original Message -
> From: "Thomas Edison Jr." <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Wednesday, February 13, 2002 7:36 PM
> Subject: Re: [PHP] Re-Importing .CSV file into
> Database
>
>
>
ua
mailto:[EMAIL PROTECTED]
- Original Message -
From: "Thomas Edison Jr." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, February 13, 2002 7:36 PM
Subject: Re: [PHP] Re-Importing .CSV file into Database
> Val,
>
> quite fr
Val,
quite frankly, i'm not quite sure i know what you're
talking about. i don't think i know enum() function!!
T. Edison jr.
--- val petruchek <[EMAIL PROTECTED]> wrote:
> > Hi Rick,
> >
> > Thanks for the support!
> > This is the mySQL Table Structure :
> >
> > $sql = "CREATE table fanlist_tr
nal Message-
> From: Thomas Edison Jr.
> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 13, 2002 9:54 AM
> To: Jason Murray
> Cc: [EMAIL PROTECTED]
> Subject: RE: [PHP] Re-Importing .CSV file into
> Database
>
>
> Hi,
>
> Ok, considering the FULL PATH an
> Hi Rick,
>
> Thanks for the support!
> This is the mySQL Table Structure :
>
> $sql = "CREATE table fanlist_try (ID bigint(21) NOT
> NULL auto_increment, name varchar(50), email
> varchar(70), age int(10), sex varchar(20), country
> varchar(50), PRIMARY KEY (ID))";
sex varchar(20) sounds great.
file i'm
using...
Thanks,
T. Edison jr.
--- Rick Emery <[EMAIL PROTECTED]> wrote:
> Thomas,
>
> Can you provide your table structure and about a
> dozen lines from your file?
>
> I'd like to experiment with it on my machine.
>
> We WILL get th
PROTECTED]]
Sent: Wednesday, February 13, 2002 9:54 AM
To: Jason Murray
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP] Re-Importing .CSV file into Database
Hi,
Ok, considering the FULL PATH and the QUOTES thingy,
this is the code i'm applying :
And this is the error i'm getting :
error:You hav
AM
To: Rick Emery
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP] Re-Importing .CSV file into Database
Oh yes, definately. With the appropriate columns too.
--- Rick Emery <[EMAIL PROTECTED]> wrote:
> Has fanlist_try table been created?
>
> -Original Message-
> From: Thomas Edis
> To: Jason Murray
> Cc: [EMAIL PROTECTED]
> Subject: RE: [PHP] Re-Importing .CSV file into
> Database
>
>
> Hi,
>
> Ok, considering the FULL PATH and the QUOTES thingy,
> this is the code i'm applying :
>
> $db = mysql_connect("localhost","
Has fanlist_try table been created?
-Original Message-
From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 10:54 AM
To: Jason Murray
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP] Re-Importing .CSV file into Database
Hi,
Ok, considering the FULL PATH and
DL Neil,
OK buddy, let me be more than frank with you.. i don't
think i've been quite as confused and having the
expression "what the hell are you tryin 2 say" on my
lips in a while, as i had when i read your mail.
Hmm.. i do hope u can help me though..
T. Edison jr.
> Further to David's comm
Hi,
Ok, considering the FULL PATH and the QUOTES thingy,
this is the code i'm applying :
And this is the error i'm getting :
error:You have an error in your SQL syntax near
'fanlist_try FIELDS TERMINATED BY ',' OPTIONALLY
ENCLOSED BY '"' LINES TERMINATED' at line 1
So... what's the problem??
> > The error message might be useful, but in any case I think
> > you need to enclose the source filename in quotes; also (you
> > better check the docs here) if I remember correctly you need
> > to give the full path to the source file unless it is in the
> > mysql data directory.
>
> That's rig
> The error message might be useful, but in any case I think
> you need to enclose the source filename in quotes; also (you
> better check the docs here) if I remember correctly you need
> to give the full path to the source file unless it is in the
> mysql data directory.
That's right, it ne
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
> Hi Rick,
>
> I tries your code but i'm constantly getting some
> errors. I modified the line to try and correct the
> error, and this is the code i'm using :
>
> $db = mysql_connect("localhost","mydb","pwd");
> mysql_select_db("mydb",
ERMINATED BY '\n' ";
>
> mysql_query($query) or die("error:". mysql_error());
>
> -Original Message-----
> From: Thomas Edison Jr.
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 12, 2002 1:11 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [PH
) or die("error:". mysql_error());
-Original Message-
From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 1:11 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP] Re-Importing .CSV file into Database
I have space on a server on the internet. I have mySQL
&a
; The file is located on the server and you have
> access to it, yes. If the
> file is on the client, then no
>
> -Original Message-
> From: Thomas Edison Jr.
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 12, 2002 12:21 PM
> To: Rick Emery
> Subject: RE: [PHP
> Glory!
>
> I have a bunch of .CSV (Microsoft Excel Comma
> Seperated Values) Files with me, whose data i want to
> put back into my mySQL database tables. How can i do
> that through php? or otherwise...
Take a look at MySQL-Front - its menu system talks about CSV (I've not had an excuse
to
look at MYSQL's LOAD DATA INFILE command:
LOAD DATA INFILE "datafile.csv" INTO mytable FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'
-Original Message-
From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 12:02 PM
To: [EMAIL P
23 matches
Mail list logo
