sql mode and displaying the programs output...

sql mode and displaying the programs output...

[Jeff D. Hamann]

I've been using sql-mode for some time now (with MySQL) and love it. I've
used it on both Windows and FreeBSD (sadly I do most of my work on Windows
though) and have noticed that the output the prompt and output on the
windows machine isn't displayed. So when I start a SQL session in emacs I
would normall see (in *nix):


Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.0.11-gamma-max-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database forestco;
Query OK, 1 row affected (0.05 sec)

mysql>


Normally this would be a big deal, But I'm writing a workbook where I need
to cut-n-paste lots of the intermediate steps and I'm using emacs to edit my
text. Is there some way to alter the settings in emacs to make sure I see
the "intermediate" output from MySQL on Windows.

Jeff.


---
Jeff D. Hamann
Forest Informatics, Inc.
PO Box 1421
Corvallis, Oregon USA 97339-1421
(office) 541-754-1428
(cell) 541-740-5988
jeff.hamann@forestinformatics.com
www.forestinformatics.com

Re: sql mode and displaying the programs output...

[Kevin Rodgers]

Jeff D. Hamann wrote:

> I've been using sql-mode for some time now (with MySQL) and love it. I've
> used it on both Windows and FreeBSD (sadly I do most of my work on Windows
> though) and have noticed that the output the prompt and output on the
> windows machine isn't displayed.


Perhaps MySQL is writing its prompt and output directly to the terminal, instead
of to standard output (and/or standard error).  You could ask the MySQL mailing
lists or newsgroup (comp.database.mysql?).

-- 
Kevin Rodgers