From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: "Corey Foote" Newsgroups: gmane.emacs.help Subject: Re: MySQL exits abnormally in Emacs Date: Fri, 15 Dec 2006 22:37:36 -0500 Message-ID: References: NNTP-Posting-Host: dough.gmane.org Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-Trace: sea.gmane.org 1166240287 22965 80.91.229.10 (16 Dec 2006 03:38:07 GMT) X-Complaints-To: usenet@sea.gmane.org NNTP-Posting-Date: Sat, 16 Dec 2006 03:38:07 +0000 (UTC) Cc: help-gnu-emacs@gnu.org Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Sat Dec 16 04:38:05 2006 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by dough.gmane.org with esmtp (Exim 4.50) id 1GvQN4-0004Uv-JX for geh-help-gnu-emacs@m.gmane.org; Sat, 16 Dec 2006 04:37:58 +0100 Original-Received: from localhost ([127.0.0.1] helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1GvQN4-0001En-4a for geh-help-gnu-emacs@m.gmane.org; Fri, 15 Dec 2006 22:37:58 -0500 Original-Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1GvQMq-0001Ea-WE for help-gnu-emacs@gnu.org; Fri, 15 Dec 2006 22:37:45 -0500 Original-Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1GvQMo-0001EO-8g for help-gnu-emacs@gnu.org; Fri, 15 Dec 2006 22:37:43 -0500 Original-Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1GvQMo-0001EI-3H for help-gnu-emacs@gnu.org; Fri, 15 Dec 2006 22:37:42 -0500 Original-Received: from [65.54.246.225] (helo=bay0-omc3-s25.bay0.hotmail.com) by monty-python.gnu.org with esmtp (Exim 4.52) id 1GvQMo-0004HN-1t for help-gnu-emacs@gnu.org; Fri, 15 Dec 2006 22:37:42 -0500 Original-Received: from hotmail.com ([65.55.133.120]) by bay0-omc3-s25.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Fri, 15 Dec 2006 19:37:40 -0800 Original-Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 15 Dec 2006 19:37:40 -0800 Original-Received: from 65.55.133.123 by by128fd.bay128.hotmail.msn.com with HTTP; Sat, 16 Dec 2006 03:37:36 GMT X-Originating-IP: [68.32.38.248] X-Originating-Email: [coreyfoote@hotmail.com] X-Sender: coreyfoote@hotmail.com In-Reply-To: Original-To: lekktu@gmail.com X-OriginalArrivalTime: 16 Dec 2006 03:37:40.0163 (UTC) FILETIME=[898AB930:01C720C3] X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.help:39614 Archived-At: 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" >To: "Corey Foote" >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 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