Re: LOAD DATA vs INSERT - MySQL

Give the complete path to the file and make sure the file is readable by everybody. LOAD DATA LOCAL INFILE "/home/bruno/data/myfile.txt" INTO TABLE mytable; To make sure the file is readable in the shell: chmod +r /home/bruno/data/myfile.txt ----- Original Message ----- Sent: Monday, October 02, 2000 5:45 PM Subject: [PHP] LOAD DATA vs INSERT - MySQL Hi everybody, Maybe one of you can help me to find out how does the LOAD DATA command works in MySQL. I saw a command line like this: LOAD DATA LOCAL INFILE "myfile.txt" INTO TABLE mytable; The problem is that i don´t know how to access this file, because i am in a MySQL prompt, not in a shell prompt!!!! A apreciate some help on this Thanks in advance Bruno Almeida