do you mean to execute a query that's written in a file? if so, there are two ways: for bournse shell type shells ( including WinNT/2K ) mysql --user=myname --password=mypassword -D dbname -v < file.sql > outfile.log2&>1 for c-shell based shells mysql --user=myname --password=mypassword -D dbname -v < file.sql >& outfile.log
or from inside a session: mysql > \T outfile.log mysql> \. file.sql copy of query and output captured in outfile.log. At 4/22/2002 05:38 PM, you wrote: >Hi everyone, > >I know that one can execute queries through files. can anyone please tell >me how to do that. I am working on sgi-irix and mysql 3.22.*. > >also how can i view previous messages on mailing list since i just joined >the list yesterday. > >SMIB, >Univ of nebraska. > > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php