Prompt for a Port Number when using sql-mysql

Prompt for a Port Number when using sql-mysql

[Cristian]

Hi. I've been using the sql-mysql function for a while to interact
with our
databases and it's worked out well. Recently a coworker set up another
database on a separate port that I need to access, but I don't know
how switch between the ports easily.

Is there a way to have sql-mysql prompt you for a port number (and use
the default if you don't specify one)?

Re: Prompt for a Port Number when using sql-mysql

[Chat]

Cristian <super.sgt.pepper@gmail.com> writes:

> Hi. I've been using the sql-mysql function for a while to interact
> with our
> databases and it's worked out well. Recently a coworker set up another
> database on a separate port that I need to access, but I don't know
> how switch between the ports easily.
>
> Is there a way to have sql-mysql prompt you for a port number (and use
> the default if you don't specify one)?

sql-mysql does not prompt for port number.

Re: Prompt for a Port Number when using sql-mysql

[jungbin]

On Aug 16, 11:52 am, Cristian <super.sgt.pep...@gmail.com> wrote:
> Hi. I've been using the sql-mysql function for a while to interact
> with our
> databases and it's worked out well. Recently a coworker set up another
> database on a separate port that I need to access, but I don't know
> how switch between the ports easily.
>
> Is there a way to have sql-mysql prompt you for a port number (and use
> the default if you don't specify one)?

Try to add follwoing line in your dot emacs file

(setq sql-mysql-options '("-C" "-t" "-f" "-n" "--
port=your_port_number"))

Let me know if it works.  I think I got it from some where on the net.