From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: "Munawar Cheema" Newsgroups: gmane.emacs.help Subject: Help on M-x sql-mysql Date: Sun, 23 Mar 2008 20:25:41 -0000 Message-ID: <000001c88d24$10a50b50$4101a8c0@workstation1> NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Trace: ger.gmane.org 1206327366 30115 80.91.229.12 (24 Mar 2008 02:56:06 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Mon, 24 Mar 2008 02:56:06 +0000 (UTC) To: Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Mon Mar 24 03:56:36 2008 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by lo.gmane.org with esmtp (Exim 4.50) id 1JdcrU-0007L2-5g for geh-help-gnu-emacs@m.gmane.org; Mon, 24 Mar 2008 03:56:36 +0100 Original-Received: from localhost ([127.0.0.1] helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Jdcqt-0000m8-EW for geh-help-gnu-emacs@m.gmane.org; Sun, 23 Mar 2008 22:55:59 -0400 Original-Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1JdWl5-0004H6-L6 for help-gnu-emacs@gnu.org; Sun, 23 Mar 2008 16:25:35 -0400 Original-Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1JdWl4-0004Gk-SK for help-gnu-emacs@gnu.org; Sun, 23 Mar 2008 16:25:35 -0400 Original-Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1JdWl4-0004Gh-Ph for help-gnu-emacs@gnu.org; Sun, 23 Mar 2008 16:25:34 -0400 Original-Received: from smtp804.mail.ird.yahoo.com ([217.146.188.64]) by monty-python.gnu.org with smtp (Exim 4.60) (envelope-from ) id 1JdWl3-0006US-3L for help-gnu-emacs@gnu.org; Sun, 23 Mar 2008 16:25:34 -0400 Original-Received: (qmail 88955 invoked from network); 23 Mar 2008 20:25:30 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=btinternet.com; h=Received:X-YMail-OSG:X-Yahoo-Newman-Property:From:To:Subject:Date:Message-ID:MIME-Version:Content-Type:Content-Transfer-Encoding:X-Mailer:Thread-Index:X-MimeOLE; b=0V+JSsLQulU4C18VaqOyhYr8mvYfrnu631vDj+WVTrAojWT0P8ngBU3PmZAEn7P7O8rDvA1p0me4bH7h68Rhy4oxeWx2TMZqaiZe0RuVfwOfYbbqNA6B80fYFXBg0jOGeHDINBvL4K7ZCQhywHUmC0qaqRGUXPuMyGGqPE7sARQ= ; Original-Received: from unknown (HELO workstation1) (mcheema@btinternet.com@86.130.117.5 with login) by smtp804.mail.ird.yahoo.com with SMTP; 23 Mar 2008 20:25:29 -0000 X-YMail-OSG: Dctj6VMVM1kDYbhU8Ts9AbvOxAbnGbjJrkoIRY.K6efvuPpjw4Y4.kQw.AbNBl1RD66c8dxDYg-- X-Yahoo-Newman-Property: ymail-3 X-Mailer: Microsoft Office Outlook 11 Thread-Index: AciNJBAR4V/4vUNFR0mbSpJgqmFzmw== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 X-detected-kernel: by monty-python.gnu.org: Genre and OS details not recognized. X-Mailman-Approved-At: Sun, 23 Mar 2008 22:54:53 -0400 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:52661 Archived-At: I was wondering if anyone on the list knows why some output from MySQL does not show in the SQL buffer. For example the prompt won't show at all. And after a command like Show tables; I'll see ouput of the form +---------------------+ |Tables***** | +---------------------+ | table1 | | table2 | +---------------------+ But it will not show the status at the end of the output line such as 2 rows in set (0.00 sec) This happens to all commands such as select etc. I have tried all kind of combinations of the sql-mysql-options Variable. Currently it is: (setq sql-mysql-options '("-t" "-f" "-n" "-u=root" "-B" "-i" "-q") I have googled for this problem and seen no solution to the problem So was hoping someone on the list could help. It would be nice to be able to see the prompt and all the output from MySQL. Regards Munawar Cheema