no output in sql mode of GNU Emacs on WinXP

I am using WinXP, GNU Emacs 23, MySQL 5.
When I start a mysql process with `sql-mysql' in emacs, no output is
displayed in the buffer until I quit or kill the process.

After I add the following line into the initialization file of emacs,


(setq sql-mysql-options '("-C" "-t" "-f" "-n"))

the output comes out, but the status line still doesn't show up. (e.g.
1
row in set (0.02 sec))

What's worse, I try to log the session with `\T logfile', but no
logfile
is generated. ( I check that with Google Desktop)

Thanks for your help.

Jieqi

Re: no output in sql mode of GNU Emacs on WinXP

;; set MySQL
(setq sql-mysql-program "d:/mysoft/mysql5/bin/mysql")
(setq sql-mysql-options '("-C" "-t" "-f" "-n" "--port=22222"))
;; truncate lines for long tables
(add-hook 'sql-interactive-mode-hook
(function (lambda ()
(setq truncate-lines t))))
(setq auto-mode-alist
(append
(list
;; insert entries for other modes here if needed.
(cons "\.sq$" 'sql-mode))
auto-mode-alist))
(add-hook 'sql-mode-hook 'font-lock-mode)

"sparkw"
??????:1155369154.208955.98080@i42g2000cwa.googlegroups.com. ..
>I am using WinXP, GNU Emacs 23, MySQL 5.
> When I start a mysql process with `sql-mysql' in emacs, no output is
> displayed in the buffer until I quit or kill the process.
>
> After I add the following line into the initialization file of emacs,
>
>
> (setq sql-mysql-options '("-C" "-t" "-f" "-n"))
>
> the output comes out, but the status line still doesn't show up. (e.g.
> 1
> row in set (0.02 sec))
>
> What's worse, I try to log the session with `\T logfile', but no
> logfile
> is generated. ( I check that with Google Desktop)
>
> Thanks for your help.
>
> Jieqi
>
>

Re: no output in sql mode of GNU Emacs on WinXP

Koocyton wrote:
> ;; set MySQL
> (setq sql-mysql-program "d:/mysoft/mysql5/bin/mysql")
> (setq sql-mysql-options '("-C" "-t" "-f" "-n" "--port=22222"))

when I added "--port=22222", I can't connect to the local mysql server
which is using the default 3306 port. The erros message is

ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost'
(10061)

Process SQL exited abnormally with code 1


> ;; truncate lines for long tables
> (add-hook 'sql-interactive-mode-hook
> (function (lambda ()
> (setq truncate-lines t))))
> (setq auto-mode-alist
> (append
> (list
> ;; insert entries for other modes here if needed.
> (cons "\.sq$" 'sql-mode))
> auto-mode-alist))
> (add-hook 'sql-mode-hook 'font-lock-mode)
>
> "sparkw"
> ??????:1155369154.208955.98080@i42g2000cwa.googlegroups.com. ..
> >I am using WinXP, GNU Emacs 23, MySQL 5.
> > When I start a mysql process with `sql-mysql' in emacs, no output is
> > displayed in the buffer until I quit or kill the process.
> >
> > After I add the following line into the initialization file of emacs,
> >
> >
> > (setq sql-mysql-options '("-C" "-t" "-f" "-n"))
> >
> > the output comes out, but the status line still doesn't show up. (e.g.
> > 1
> > row in set (0.02 sec))
> >
> > What's worse, I try to log the session with `\T logfile', but no
> > logfile
> > is generated. ( I check that with Google Desktop)
> >
> > Thanks for your help.
> >
> > Jieqi
> >
> >