RE: MS-DOS Window - Dave Watkinson - com.mysql.lists.win32

10 messages in com.mysql.lists.win32RE: MS-DOS Window

From	Sent On	Attachments
Robbie Martinez	04 Mar 2002 15:30
webm...@w3space.com	04 Mar 2002 15:48
Miguel Angel Solorzano	04 Mar 2002 17:46
Pete French	05 Mar 2002 02:10
Matthew Stanfield	05 Mar 2002 03:47
Robbie Martinez	05 Mar 2002 06:48
Dave Watkinson	05 Mar 2002 06:51
holl...@gmx.net	05 Mar 2002 07:34
Eduardo Silva	05 Mar 2002 12:03
Kevin Farley	06 Mar 2002 05:45

Subject:	RE: MS-DOS Window
From:	Dave Watkinson (d.wa...@mightymatch.com)
Date:	03/05/2002 06:51:42 AM
List:	com.mysql.lists.win32

If you are trying to capture select queries do this

SELECT thiscolumn, thatcolumn, theothercolumn FROM thistablename WHERE somecriteria AND etc etc etc ORDER BY thiscolumn INTO OUTFILE 'somefilename.txt' ;

doesn't work with DESCRIBE or SHOW TABLES tho

Hope this helps

Dave

-----Original Message----- From: Robbie Martinez [mailto:roma...@ssd.usa.alcatel.com] Sent: 04 March 2002 23:31 To: win...@lists.mysql.com 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,