help, load data error
Posted by:
leo shen
Date: June 08, 2005 08:14PM
Hi, guys
I am a newcomer of mysql. I installed it on windows. I am studying the manual of it and encountered a problem when doing :
To load the text file pet.txt into the pet table, use this command:
mysql> LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet;
I created a pet.txt file under mysqlXX\data folder, but i do not know how to load it into mysql.
and always get ERROR 2 (HY000): File 'pet.txt' not found (Errcode: 2)
can u give me a hand ? thanks
Subject
Written By
Posted
help, load data error
June 08, 2005 08:14PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.