Linux Certif

Toute la documentation sur la certification Linux LPI

query

NAME

query - execute a query

SYNOPSIS

query host port socket user passwd query [debug]
query [-config configfile] -id id query [debug]

DESCRIPTION

The query command executes the query specified in the query parameter and returns the result set as a quote/comma/return seperated value list to standard output.

OPTIONS

host

hostname of the machine running the listener daemon

port

port number the listener daemon is listening on, for local or remote connections

socket

socket the listener daemon is listening on, for local connections

user

SQL Relay user name (as per config file)

passwd

SQL Relay password (as per config file)

-config configfile

config file to use (default /etc/sqlrelay/sqlrelay.conf)

-id id

instance to use (as per config file)

query

query to be executed

debug

produce debugging output

EXAMPLES

query "" "" /tmp/examplesocket fred secret "select * from tbl"

Connect to the SQL Relay listener daemon running on the local machine, with socket /tmp/examplesocket, as user fred, with password secret, and run a query.

query dbsvr 9000 "" fred secret "select * from tbl" debug

Connect to the SQL Relay listener daemon running on the remote machine dbsvr, on port 9000, as user fred, with password secret, and run a query, producing extra debugging output.

query -id example "select * from tbl"

Connect to the SQL Relay listener daemon for instance example (as defined in /etc/sqlrelay/sqlrelay.config), and run a query.

SEE ALSO

fields(1), #query(1), sqlr-config-gtk(1), sqlrsh(1), sqlr-cachemanager(8), sqlr-connection(8), sqlr-listener(8), sqlr-scaler(8), sqlr-start(8), sqlr-stop(8), and the documentation in /usr/share/doc/sqlrelay.

AUTHORS

This manual page was written by Andreas Tille <tille@debian.org> and Florian M. Weps <fweps@pop.agri.ch>, for the Debian GNU/Linux system (but may be used by others).