Man Linux: Main Page and Category List

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),  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).