Content-type: text/html Man page of BOOTS

BOOTS

Section: Drizzle Database System (1)
Updated: 2010-03-07
Index Return to Main Contents

NAME

boots - the Boots command-line tool

SYNOPSIS

boots [OPTION]

DESCRIPTION

Boots is an SQL shell which provides a command line interface to relational database servers. When used interactively it presents query results in an ASCII-table format. When used non-interactively it presents results in a tab-separated format.

OPTIONS

-c, --command: Execute a command and exit.
-D, --database: Indicate the database to use.
-f, --script: Execute commands from a file and exit.
-F, --historyfile: Save history to specified file.
-?, --help: Display boots client help information and exit.
-H=host_name, --host host_name: Connect to the Drizzle server on the given host.
-l, --lingo: Set the lingo to use.
-L, --historylength: Specify maximum history file length.
-X, --norc: Do not read user configuration file.
-r, --rc: Filename of user configuration file.
-p=port_num, --port port_num: The TCP/IP to use to connect to the drizzled server.
-P, --password: Connect using the password. If none is given, query for the password.
-t, --terminatingchar: Specify the SQL statement terminating character. The default is ';'.
-u, --user: Login with user name.

EXAMPLES

Connecting to a Drizzle Server

To connect to the database ``test'' in a Drizzle server running on localhost and listening on port 9306:
boots --host=localhost --port=9306 -D test

Executing SQL commands in a File

To connect to the Drizzle server in the previous example, running SQL commands from a file ``./myscript'':
boots --host=localhost --port=9306 -D test -f ./myscript