no output in sql mode of GNU Emacs on WinXP

[sparkw]

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

[Koocyton]

;; 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" <ji*******@gmail.com>
??????:11*********************@i42g2000cwa.googleg roups.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

[sparkw]

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" <ji*******@gmail.com>
??????:11*********************@i42g2000cwa.googleg roups.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