Search code examples
sqlemacssql-mode

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 be done? Is there a way to instead change your connection info for the existing buffer?

Solution

  • Running:

    M-x sql-rename-buffer

    On a connected *SQL* buffer will rename the current buffer after the current connection. So:

    *SQL*

    Becomes:

    *SQL user/database*

    You can then do:

    M-x sql-mysql

    Or whatever your flavor of DB is to create another SQL buffer.