MSQL(1)

NAME
msql - Mini SQL Terminal Monitor

SYNOPSIS
msql [ -h host ] [ -q ] database

DESCRIPTION
Like all database applications, mSQL provides a program that allows a user to interactively submit queries to the database engine. In the case of mSQL, it's a program simply called `msql'. It requires one command line argument, being the name of the database to access. Once started, there is no way to swap databases without restarting the program. this program is the main user interface to the database engine. This monitor hasn been modelled after the original Ingres (and the subsequent Postgres) monitor program. See libmsql(3) for Details in specifying a hostname. You may get full access to the database via mSQL queries according configured access rules. Each query must be followed by ` (see later) to get sent to the engine. See msql(5) for the supported subset of ANSI-SQL.

COMMANDS
Queries and commands are distinguished due to commands being prefixed by backslashes.

\\e Edit the last query using the vi editor. If you wish to use an editor other than vi, msql will honour the convention of using the contents of the VISUAL or EDITOR environment variable as an alternate editor.

\\g Each query that is sent to the database engine must be followed by this command. It tells the monitor to "go" and send the query to the engine. If `\g' ist entered without entering a new query, the last query to be submitted will be resubmitted.

\\p The contents of the query buffer can be displayed more than once.

\\q Quit the mSQL monitor program.

ENVIRONMENT
The mSQL program family may be controlled by some environment variables. They override compiled-in default values but may be overridden by commandline arguments.

MSQL_TCP_PORT
    Specifies the TCP port on which the database engine listen to requests.

MSQL_UNIX_PORT
    Specifies the unix domain socket that shall be used to contact the engine if it runs on the local host.

MINERVA_DEBUG
    Specifies debuging. See libmsql(3) for possible values.

VISUAL, EDITOR
    If the query shall be edited you may specify your favourite editor here.

AUTHOR
Mini SQL has been written by David Hughes of Bond University, Australia as part of the Minerva Network Management Environment. He may be reached via electronic mail using bambi@Bond.edu.au.

SEE ALSO
libmsql(3), msql(5).