I am new to MySQL. I am going through the tutorial. I came to the part where they tell you how you can make MySQL read in a text file. I put my file PET.TXT into the C:\ directory and then typed and recieved the following message:

mysql> LOAD DATA LOCAL INFILE 'C:\PET.TXT' INTO TABLE PET;
ERROR 2 (HY000): File 'C:PET.TXT' not found (Errcode: 2)

1) where should I put my text file
2) is this the right command for reading in the file

Thank you for helping in advance.
Bryan

Try this syntax - 'C:/PET.TXT'

Note that if you created the file on Windows with an editor that uses \r\n as a line terminator, you should use:

mysql> LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet
-> LINES TERMINATED BY '\r\n';


note example from mysql help - "Lines Terminated by \r\n" was recomended in Windows