on 02/04/2004 02:23 AM, Bernd Tannenbaum at [EMAIL PROTECTED] 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 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
