[linux-help] Re: Mysql permissions

[Jeff Vian <jvian10@xxxxxxxxxxx>]

bruce bales wrote:

>Tom Hull wrote:
>
>  
>
>>Another way to do this would be to redirect the output of mysql to whatever
>>file you want to capture the data. You might, for instance:
>>
>>  $ echo 'select * from foo;' | mysql >foo.select
>> 
>>
>>    
>>
>This worked.  After I figured out how to put in name and PW.
>
>[bruce@bertha temp]$  echo 'select * from class50.email;' | mysql -u 
>bruce -p >email2.dat
>Enter password:
>[bruce@bertha temp]$
>  
>
This should be almost the same as doing
   mysql -u bruce -p
        Enter password:
    use class50;
    select * into 'email.dat' fields terminated by ',' from email;

-------------------------------------------------------------------

I noticed that your original post gave the command as:

    select * into outfile 'email.dat' fields terminated by ',' from 
emailaddr;

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.



>  
>

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