Re: MySQL exits abnormally in Emacs

[Corey Foote]

Thanks for your reply to my posting. However, I think I didn't explain
the problem I'm having well enough. Please allow me to try to describe it
more clearly.

When I type queries into the process buffer and press enter, no
results are returned until I interrupt the process with C-c C-c. Only
when the process is interrupted are any results returned. The results
off all queries are then returned together and without any boxes being
drawn around them. For example, if I type into the process buffer the
following:

select now();RET

select count(*) from mysql.user;RET

No results are returned until I type C-c C-c in the process buffer at
which point the results are returned all at once and without
formatting:

 C-c C-cnow()
2006-12-15 22:15:55
count(*)
5

Process SQL exited abnormally with code 1

It would be nice to be able to get the results I need without having
to terminate the process in order to see them.

Thanks again,

Corey Foote
coreyfoote@hotmail.com



> From: "Juanma Barranquero" <lekktu@gmail.com>
> To: "Corey Foote" <coreyfoote@hotmail.com>
> CC: help-gnu-emacs@gnu.org
> Subject: Re: MySQL exits abnormally in Emacs
> Date: Fri, 15 Dec 2006 19:16:55 +0100
>
> On 12/14/06, Corey Foote <coreyfoote@hotmail.com> wrote:
>
> > I type my query and press C-c C-c and get the following error:
> >
> > select now();  C-c C-cnow()
> > 2006-12-14 14:11:25
> >
> > Process SQL exited abnormally with code 1
>
> Where do you type C-c C-c? If it is in the process buffer (the one
> where mysql is running), C-c C-c is bound to
> `comint-interrupt-subjob', so it's no wonder that it gets interrupted.
> In that buffer it's enough to press ENTER after queries:
>
> select count(*) from mysql.user;
> +----------+
> | count(*) |
> +----------+
> |        5 |
> +----------+
>
> C-c C-c (`sql-send-paragraph') is used from a SQL buffer that you
> associate with the inferior process (the subprocess) that is running
> mysql.  For example, create a buffer in SQL mode (either setting it
> with "M-x sql-mode" or visiting a .SQL file), and then do "M-x
> sql-product-interactive", or choose the option "Start SQLi Session" in
> the SQL menu.  That way you'll have a running mysql client in a buffer
> associated with your SQL source buffer. Then you can write SQL code in
> your source buffer and send it to the inferior process with C-c C-c.
>
> Take a look at the file lisp/progmodes/sql.el.
>
>                    /L/e/k/t/u

_________________________________________________________________
Get the latest Windows Live Messenger 8.1 Beta version. Join now. 
http://ideas.live.com