[snip]
It's a little messy but that's the only other way I can think of doing
it.
Sorry.
[/snip]
If he has the file locally to himself he can do this via phpMyAdmin
through the load text file option. Depending on the version there is
always a way to load files ... even to remote servers
For i
is_one` FIELDS
> TERMINATED BY ';' LINES TERMINATED BY '\r\n'
>
> I am using phpMyAdmin 2.3.3 - would an upgrade to the latest version
> remedy the issue?
>
> Thanks,
>
> -Mike
>
>
>
>> -Original Message-
>> From: Donald Tyler
[snip]
Sorry, that is the error - my mistake. I am getting this:
LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS
TERMINATED BY ';' LINES TERMINATED BY '\r\n'
[/snip]
Mike, could we see just a bit of the php9GOwvw file...just out of
curiosity
--
MySQL General Mailing List
Fo
nks,
-Mike
> -Original Message-
> From: Donald Tyler [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 08, 2003 3:42 PM
> To: [EMAIL PROTECTED]
> Subject: RE: mysql LOAD DATA INFILE
>
>
> PHPMyAdmin uses the "LOAD DATA LOCAL INFILE" command. Just re
[snip]
70050;451
70322;451
> LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS
> TERMINATED BY ';' LINES TERMINATED BY '\r\n'
> [/snip]
[/snip]
I am going to recommend that you specify which columns the data goes
into
> LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_
o: Mike At Spy; Donald Tyler; [EMAIL PROTECTED]
> Subject: RE: mysql LOAD DATA INFILE
>
>
> [snip]
> 70050;451
> 70322;451
>
> > LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS
> > TERMINATED BY ';' LINES TERMINATED BY
; Sent: Friday, August 08, 2003 4:08 PM
> To: [EMAIL PROTECTED]
> Subject: RE: mysql LOAD DATA INFILE
>
>
> Oh and just a note. This solution won't work if you are uploading the file
> to the server through the browser. You will need to put the file on the
> server
[snip]
I see you still have the word LOCAL in there. Did you try and remove it?
To do that in PHPMyAdmin you will need to run the import so you get the
error message and then copy and paste it into the SQL section of the
PHPMyadmin tool. Delete the world LOCAL and then run the query. It
should
wor
MAIL PROTECTED]
> Sent: Friday, August 08, 2003 3:24 PM
> To: Donald Tyler; [EMAIL PROTECTED];
> [EMAIL PROTECTED]
> Subject: RE: mysql LOAD DATA INFILE
>
>
> Ah. No wonder it dinna work. Neither did specifying the columns as Jay
> suggested.
>
> I also have no choic
over 15,000 of them. :)
-Mike
> -Original Message-
> From: Jay Blanchard [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 08, 2003 3:58 PM
> To: Mike At Spy; Donald Tyler; [EMAIL PROTECTED]
> Subject: RE: mysql LOAD DATA INFILE
>
>
> [snip]
> Sorry, that
the
PHPMyadmin tool. Delete the world LOCAL and then run the query. It should
work.
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08, 2003 2:59 PM
To: Donald Tyler; [EMAIL PROTECTED]
Subject: RE: mysql LOAD DATA INFILE
Sorry, that is the error - my
PHPMyAdmin uses the "LOAD DATA LOCAL INFILE" command. Just remove the word
LOCAL and it should work fine.
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08, 2003 2:35 PM
To: [EMAIL PROTECTED]
Subject: mysql LOAD DATA INFILE
When I come across this er
At 13:13 -0600 2/22/02, Craig Westerman wrote:
>I have a table that has following fields
>
>id (auto increment)
>date
>appleprice
>orangeprice
>pearprice
>
>When I try to LOAD DATA INFILE with this file using comma as field delimiter
>and newline as end of row
You need to add the column list:
.
You need to specify the columns you're loading, if they aren't all the
columns in the table in the same order. So, you need to add
(date, appleprice, orangeprice,pearprice)
at the end of your LOAD DATA INFILE statement.
As for only loading one row, I'd guess your input file line endings don'
14 matches
Mail list logo
