LOAD DATA vs INSERT - MySQL
| From: | Bruno Mário Amaral Almeida | Date: | Tue, 03 Oct 2000 00:45:28 +0000 |
| Subject: | LOAD DATA vs INSERT - MySQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-18336@lists.php.net to get a copy of this message | ||
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