The first row of the result contains the symbolic name of the index

mechanism used to store the index. Rows 2 and onwards contain the name

of the fields that comprise the index. For example, if a compund index was

defined as an AVL Tree index and was

based on the values of the fields 

first_name

 and

last_name

, then the result table would look like

row[0]

avl

first_name

last_name

Currently the only valid index type is  avl  signifying a

G   

memory mapped AVL tree.

Mini SQL 2.0 (Beta) Standard Programs and Utilities

The monitor   msql

Usage

msql [ h host] [ f confFile] database

Options

 h Specify a remote hostname or IP address on which the mSQL server is running. The default

is to connect to a server on the localhost using a UNIX domain socket rather than TCP/IP

(which gives better performance)

 f Specify a non default configuration file to be loaded. The default action is to load the

standard configuration file located in INST_DIR/msql.conf (usually

/usr/local/Hughes/msql.conf)

Description

The mSQL monitor is an interactive interface to the mSQL server. It allows

you to submit SQL commands directly to the server. Any valid mSQL syntax

can be entered at the prompt provided by the mSQL monitor.

Control of the monitor itself is provided by 4 internal commands. Each

G   

command is comprised of a backslash followed by a single character.

The available command are

\q

Quit

\g

Go (Send the query to the server)

\e

Edit (Edit the previous query)

\p

Print (Print the query buffer)