RE: mysql LOAD DATA INFILE

[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

Re: mysql LOAD DATA INFILE

[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 remove >> the word LOCAL and it should work fine. &g

RE: mysql LOAD DATA INFILE

[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

FW: mysql LOAD DATA INFILE

iday, 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 choice but to do it through the browser - I don't have command line

RE: mysql LOAD DATA INFILE

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

mysql LOAD DATA INFILE

When I come across this error: The used command is not allowed with this MySQL version Does this mean that I need a whole different verison of MySQL, or just a different compile? The command was 'LOAD DATA INFILE' and I was doing it through phpMyAdmin. Thanks, -Mike -- MySQL General Maili

FW: mysql LOAD DATA INFILE

. -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 mistake. I am getting this: LOAD DATA LOCAL INFILE '/tmp/php9GOwvw'

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 '\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_

RE: mysql LOAD DATA INFILE

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 

RE: mysql LOAD DATA INFILE

; 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

RE: mysql LOAD DATA INFILE

[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

RE: mysql LOAD DATA INFILE

hanks, -Mike > -Original Message- > From: Donald Tyler [mailto:[EMAIL PROTECTED] > Sent: Friday, August 08, 2003 4:30 PM > To: [EMAIL PROTECTED] > Subject: FW: mysql LOAD DATA INFILE > > > Then the only way you can do it that I can think of is to write a > PHP script &

RE: mysql LOAD DATA INFILE

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

RE: mysql LOAD DATA INFILE

st 08, 2003 3:07 PM To: '[EMAIL PROTECTED]' Subject: FW: mysql LOAD DATA INFILE 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

RE: mysql LOAD DATA INFILE

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 a

MYSQL: LOAD DATA INFILE and 'äöü' Characters

MYSQL: I have problems with importing data including characters like 'äöü'. These characters where translated to some other unusable characters. In the command line with a single insert statement the 'äöü' characters are accepted! Can help someone ? Thanks Enrico Kratter Alpenblickstrasse 30 CH-8

Re: MySQL Load Data Infile

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: .

Re: MySQL Load Data Infile

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'

MySQL Load Data Infile

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 "2000-01-04","281.08","5.27","430.05" "2000-01-05","280.06","5.14","421.98" "2000-01-06","279