bug#7664: sql.el: In interactive sql-<product> command, Add C-u to set connection port

[Michael Mauger]

In Emacs 24, SQL.el supports the port login parameter. 

By customizing `sql-mysql-login-params'  to include the atom `port' the port will be prompted for during login.  If you don't specify a value, it will not be specified when you connect so it will use the default.   You can also set a default value for port by customizing `sql-port'.

   (setq sql-mysql-login-params '(user password server port database))

Both MySQL and Postgres support the use of port during login. 

---

From: Chong Yidong <cyd@stupidchicken.com>
To: Michael R. Mauger <mmaug@yahoo.com>
Cc: Jari Aalto <jari.aalto@cante.net>; 7664@debbugs.gnu.org
Sent: Tue, December 21, 2010 1:59:40 AM
Subject: Re: bug#7664: sql.el: In interactive sql-<product> command, Add C-u to set connection port

Jari Aalto <jari.aalto@cante.net> writes:

> In production environments the database servers run in multiple ports,
> like
>
>    M-x sql-mysql
>
> It would be nice to be able to specify PORT number during interactive
> call, like:
>
>    C-u M-x sql-mysql
>    ...
>    Port: .....

Michael, could you take a look at this wishlist item?  Currently,
sql-mysql already uses a prefix argument to output into a new buffer.
If you decide this suggestion is worth implementing, there are a couple
of possibilities: (i) add another interactive command that prompts for a
port number, or (ii) change the interactive spec so that a prefix arg
prompts the user about whether to use a new buffer and what port to use.
I don't use sql.el, so I don't know which makes more sense.