Hi Robbie, There are a few ways you can capture the output to a file.. First of all, you can have all your sql statement in a file , say myquery.sql file, and call it from command line and redirect it to a different file such as this: C:\mysql\bin\mysql < myquery.sql > outputfile.txt Or, you can select your query into a outfile with SELECT .... INTO OUTFILE 'outfile.txt'; syntax. See http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SEL ECT for this ... OR, you can use the tee command in mysql> prompt... Just do : mysql>tee outfile.txt mysql>select blah, blah; mysql>notee
Hope this helps... Gurhan, -----Original Message----- From: Robbie Martinez [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 6:31 PM To: [EMAIL PROTECTED] Subject: MS-DOS Window This may be a simple MS-DOS question, but I'm a UNIX guy and am pretty clueless... I'm trying to capture some mysql command output, but my DOS screen runs out of space. In other words, the data goes beyond what I can scroll up to get. Is there any way for me to either: (1) Redirect output from mysql commands to a file (2) Create a session "typescript" of mysql (3) Increase the DOS window's scroll memory to a very large size (so I don't lose my data on my screen). Thanks, --------------------------------------------------------------------- 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
