From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: "Gary ." Newsgroups: gmane.emacs.help Subject: Re: Help with sql mode Date: Fri, 9 Apr 2010 10:08:22 +0200 Message-ID: References: <6gf197-f9t.ln1@news.eternal-september.org> <99n197-hi1.ln1@news.eternal-september.org> NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 X-Trace: dough.gmane.org 1270800650 1159 80.91.229.12 (9 Apr 2010 08:10:50 GMT) X-Complaints-To: usenet@dough.gmane.org NNTP-Posting-Date: Fri, 9 Apr 2010 08:10:50 +0000 (UTC) To: help-gnu-emacs@gnu.org Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Fri Apr 09 10:10:49 2010 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.69) (envelope-from ) id 1O09IQ-0003IB-2E for geh-help-gnu-emacs@m.gmane.org; Fri, 09 Apr 2010 10:10:34 +0200 Original-Received: from localhost ([127.0.0.1]:54041 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1O09IP-0001TB-2m for geh-help-gnu-emacs@m.gmane.org; Fri, 09 Apr 2010 04:10:33 -0400 Original-Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1O09GN-0007xD-I4 for help-gnu-emacs@gnu.org; Fri, 09 Apr 2010 04:08:27 -0400 Original-Received: from [140.186.70.92] (port=32795 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1O09GL-0007v3-7D for help-gnu-emacs@gnu.org; Fri, 09 Apr 2010 04:08:26 -0400 Original-Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1O09GJ-0004ZX-PN for help-gnu-emacs@gnu.org; Fri, 09 Apr 2010 04:08:25 -0400 Original-Received: from mail-ww0-f41.google.com ([74.125.82.41]:55913) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1O09GJ-0004ZK-Ks for help-gnu-emacs@gnu.org; Fri, 09 Apr 2010 04:08:23 -0400 Original-Received: by wwf26 with SMTP id 26so797074wwf.0 for ; Fri, 09 Apr 2010 01:08:22 -0700 (PDT) Original-Received: by 10.216.167.65 with HTTP; Fri, 9 Apr 2010 01:08:22 -0700 (PDT) In-Reply-To: <99n197-hi1.ln1@news.eternal-september.org> Original-Received: by 10.216.172.202 with SMTP id t52mr701491wel.21.1270800502179; Fri, 09 Apr 2010 01:08:22 -0700 (PDT) X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6 (newer, 2) 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:72637 Archived-At: On Thu, Apr 8, 2010 at 9:27 PM, Richard Riley wrote: > "Gary ." writes: >> On Thu, Apr 8, 2010 at 7:14 PM, Richard Riley wrote: >>> Example: >>> >>> use mydatabase; >>> select name from phonerecords where name like "Ril%"; >> >> Ah. Well I didn't do a use, I just tried >> SELECT VERSION(), CURRENT_DATE; >> and nothing happened. >> > > You don't need "use" for that. It should work. Well, yeah. That's why I asked :) Let me start from the beginning. 0. start emacs :) 1. `M-x sql-mysql' --> I am prompted for various connection infos which I answer, window is split into two, one showing the current buffer and one showing the *SQL* buffer 2. I type my query as shown previously into the *SQL* buffer --> I get some nice syntax highlighting 3. Press RET / ENTER --> the highlighting vanishes... no sign of any output anywhere... My config looks like: (require 'sql) (setq auto-mode-alist (append '(("\\.sql$" . sql-mode) ("\\.tbl$" . sql-mode) ("\\.sp$" . sql-mode)) auto-mode-alist)) That's it. The problem is I can't really find much documentation about this, it seems to one of the least documented modes I've come across :(