no output in sql mode of GNU Emacs on WinXP

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sparkw
    #1

    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

    Tags: None
    • Koocyton
      #2
      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" <jieqiwang@gmai l.com>
      ??????:11553691 54.208955.98080 @i42g2000cwa.go oglegroups.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
      >
      >

        Comment

        • sparkw
          #3
          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" <jieqiwang@gmai l.com>
          ??????:11553691 54.208955.98080 @i42g2000cwa.go oglegroups.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

            Comment

            Previous template Next
            Working...