[linux-help] Re: Mysql permissions

[bruce bales <bbales@xxxxxxx>]

Jeff Vian wrote:

>the use of the word "outfile" followed by the actual filename is not 
>legal.  It is used in the documentation to represent the filename being 
>saved to and MUST be replaced by the actual filename in the command.
>  
>
I'm afraid you're wrong here, Jeff.  The examples in the book all show:

SELECT * INTO OUTFILE 'books.dat'  FROM BOOK

If I leave out the word 'outfile', I get sql error.

Likewise, to input data from a table it's

mysql> LOAD DATA LOCAL INFILE "event.txt" INTO TABLE event;

bruce

-- This is the linux-help@xxxxxxxxx list.  To unsubscribe,
visit http://www.complete.org/cgi-bin/listargate-aclug.cgi