loading text file into mysql

[admin]

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