loading text file into mysql

[jtchang]

I am not sure how to load my text data into my mysql tables.

the function:
LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;

I am using mysql on windows system.

i am curios where should i put my pet.txt file and how should my text file look?

should it be seperated by a comma between each field or what?
any help would be appreciated

thanks
john

[Anon]

You can enter the file to be loaded with the full path, i.e.
LOAD DATA INFILE "e:/temp/file.txt" INTO TABLE pet;

This is how the text file should be formatted if you use mysql defaults (quoting the manual);
"If you don't specify a FIELDS clause, the defaults are the same as if you had written this:

FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\'

If you don't specify a LINES clause, the default is the same as if you had written this:

LINES TERMINATED BY '\n'"

Hope this helps you out!

[Anon]

I'm having a similar problem loading a csv text file into a mysql database. I have manually run the query in mysql, but when I try to run the same mysql query through php, I get a failed query. I'm using the following code. Do you see anything wrong, or do you have any suggestions?
--Bull

$query = "LOAD DATA INFILE \'jobstatus.txt\' REPLACE INTO TABLE jobstatus FIELDS TERMINATED BY \',\' OPTIONALLY ENCLOSED BY \'\"\'";
$result = mysql_query ($query)
or die('Query Failed');

[Anon]

I found the problem. I was using too many excape characters . I only needed to used escapes for the internal quotation marks, not all the apostrophes as well.

--Bull