query1
Execute a query
Usage
query host
port
socket
user
passwd
query
[debug]
query [-config
configfile]
-id
id
query
[debug]
Overview
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 |
|---|---|
|
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 userfred, with passwordsecret, 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 port9000, as userfred, with passwordsecret, 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.
Releases
Unchanged in 3 releases since Debian 3.1 (Sarge).