sql-mode

How do I connect to SQL Server using Emacs?

What steps do I take? Any gotchas to be aware of or tips to enhance the IDE experience that are specific to SQL Server when using Emacs? ...

How to make Emacs sql-mode recognize MySQL #-style comments?

I'm reading a bunch of MySQL files that use # (to end-of-line) comments, but my sql-mode doesn't support them. I found the syntax-table part of sql.el that defines /**/ and -- comments, but according to this, Emacs syntax tables support only 2 comment styles. Is there a way to add support for # comments in sql.el easily? ...

Can you create a new SQL buffer in Emacs if one already exists?

Let's say you have a *SQL* buffer already open in Emacs that is connected to a specific server and database. Now, your intention is to connect to a different server and database while keeping your other SQL buffer process active. How exactly can you create a new *SQL* buffer process without killing your original SQL buffer? Can this b...

Emacs sqli-mode (mysql) and keeping the output aligned / cursor aligned correctly?

I like to use M-x sql-mysql to interact with mysql in emacs, but I constantly (and seemingly somewhat sporadically) run into situations where for some reason emacs stops using the full height of a buffer (meaning I'll have some long output, and then the mysql> prompt will be halfway up the buffer, which is frustrating. Also, I end up h...