Re: MySql on emacs -- just double checking ??

[William Case <billlinux@rogers.com>]

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