on 02/04/2004 02:23 AM, Bernd Tannenbaum at tannenbaum@stripped
wrote:
> 2 possible ways to go:
>
> Feed a Textfile with your statement in the db:
> PATH/mysql db < /sql_scripts/sql_statements_as_textfile --password=pass
>
> Give command directly In the shell-script:
> PATH/mysql --skip-column-names -e "SELECT table SET blabla" db
> --password=pass
I need to select into outfile on this one, which poses a problem to me, I
can not write the file to any directory as I get a permissions error since
mysql is the owner of this file, how would I do this ?
--
-------------------------------------------------------------
Scott Haneda Tel: 415.898.2602
http://www.newgeo.com Fax: 313.557.5052
scott@stripped Novato, CA U.S.A.
