Use redirection:
msql mydb < statement.sql > output.txt
where statement.sql is a file that can contain one or many lines with SQL
statements, e.g.
select * from foo where id='bar'\g
select foo.id, baz.name from foo,baz where foo.id = baz.id and baz.count >
1\g
HTH
>From: john_pallozzi@itworld.com
>To: msql-list@lists.hughes.com.au
>Subject: Dumping Select Statement
>Date: Fri, 17 Dec 1999 15:04:21 -0500
>
>Hello,
>
>A quick question for the list. How do you dump the results of a select
>statement out to a file?
>
>Thanks,
>
>John P
>
>
>-------------------------------------------------------------------------
>To unsubscribe, go to http://www.Hughes.com.au/extras/email/
=====
Jesus M. Castagnetto - jcastagnetto@hotmail.com
Pilot stuff & etc.:
http://www.geocities.com/ResearchTriangle/Lab/1059/
LAB: http://www.scripps.edu/research/metallo
Metalloprotein DB: http://metallo.scripps.edu/
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
-------------------------------------------------------------------------
To unsubscribe, go to http://www.Hughes.com.au/extras/email/
This archive was generated by hypermail 2b30 : Mon Mar 04 2002 - 09:04:03 EST