* MySql on emacs -- just double checking ??
@ 2007-06-13 13:52 William Case
0 siblings, 0 replies; 3+ messages in thread
From: William Case @ 2007-06-13 13:52 UTC (permalink / raw)
To: EMACS List
Hi;
I want to write some mysql procedures on emacs . I have found the
sql-mysql interactive mode and the sql-mode. Is there a mysql
text/procedure writing mode or is the sql mode applicable to both.
And, is there an .el that has a specialized font-lock for data bases
(particularly mysql).
I have checked info and the wiki. I may have misunderstood but the
suggested patches seem to be included in emacs22 and don't *seem* to
directly address my questions?
Would appreciate any answers or pointers to where I might have missed
something.
--
Regards Bill,
Fedora Core 7, GNU Emacs 22.0.099
^ permalink raw reply [flat|nested] 3+ messages in thread
[parent not found: <mailman.2098.1181742875.32220.help-gnu-emacs@gnu.org>]
* Re: MySql on emacs -- just double checking ??
[not found] <mailman.2098.1181742875.32220.help-gnu-emacs@gnu.org>
@ 2007-06-14 13:27 ` Tim X
2007-06-14 13:54 ` William Case
0 siblings, 1 reply; 3+ messages in thread
From: Tim X @ 2007-06-14 13:27 UTC (permalink / raw)
To: help-gnu-emacs
William Case <billlinux@rogers.com> writes:
> Hi;
>
> I want to write some mysql procedures on emacs . I have found the
> sql-mysql interactive mode and the sql-mode. Is there a mysql
> text/procedure writing mode or is the sql mode applicable to both.
>
> And, is there an .el that has a specialized font-lock for data bases
> (particularly mysql).
>
> I have checked info and the wiki. I may have misunderstood but the
> suggested patches seem to be included in emacs22 and don't *seem* to
> directly address my questions?
>
> Would appreciate any answers or pointers to where I might have missed
> something.
>
> --
I use sql-mode for this. When you open a file with a .sql extension, you will
proably be put into sql mode. Once there, you can select 'mysql' as the product
and get the appropriate keyword highlighting. then, when you open an sqli
buffer (SQL interactive buffer), you can send the code or regions of code from
your sql buffer to the interactive buffer to have it executed.
Now, sql mode is not specialised for writing procedures, but you can try
something like I have done for working with PL/SQL (Oracle's procedural sql
used for writing stored procedures etc). I have defined a plsql mode which is
derived from sql mode. All I've really done is define a few extra keywords and
some formatting rules (and some align rules for nicely formatting embedded SQL
for cursors etc). This was fairly easy to do. Have a look at the derived mode
entry on the emacs wiki for an example.
regards,
Tim
--
tcross (at) rapttech dot com dot au
^ permalink raw reply [flat|nested] 3+ messages in thread
* Re: MySql on emacs -- just double checking ??
2007-06-14 13:27 ` Tim X
@ 2007-06-14 13:54 ` William Case
0 siblings, 0 replies; 3+ messages in thread
From: William Case @ 2007-06-14 13:54 UTC (permalink / raw)
To: Tim X; +Cc: help-gnu-emacs
Thanks Tim;
On Thu, 2007-06-14 at 23:27 +1000, Tim X wrote:
> William Case <billlinux@rogers.com> writes:
>
> > Hi;
>
> I use sql-mode for this. When you open a file with a .sql extension, you will
> proably be put into sql mode. Once there, you can select 'mysql' as the product
> and get the appropriate keyword highlighting. then, when you open an sqli
> buffer (SQL interactive buffer), you can send the code or regions of code from
> your sql buffer to the interactive buffer to have it executed.
>
> Now, sql mode is not specialised for writing procedures, but you can try
> something like I have done for working with PL/SQL (Oracle's procedural sql
> used for writing stored procedures etc). I have defined a plsql mode which is
> derived from sql mode. All I've really done is define a few extra keywords and
> some formatting rules (and some align rules for nicely formatting embedded SQL
> for cursors etc). This was fairly easy to do. Have a look at the derived mode
> entry on the emacs wiki for an example.
Those are the very things I wanted to check about. I could have spent a
year playing around re-inventing the wheel. I probably would have ended
up with a square wheel.
--
Regards Bill
^ permalink raw reply [flat|nested] 3+ messages in thread
end of thread, other threads:[~2007-06-14 13:54 UTC | newest]
Thread overview: 3+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2007-06-13 13:52 MySql on emacs -- just double checking ?? William Case
[not found] <mailman.2098.1181742875.32220.help-gnu-emacs@gnu.org>
2007-06-14 13:27 ` Tim X
2007-06-14 13:54 ` William Case
Code repositories for project(s) associated with this external index
https://git.savannah.gnu.org/cgit/emacs.git
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.