hk_actionquery(1)

Usage

hk_actionquery -d driver -b database [OPTIONS] queryname

Overview

hk_actionquery executes a query that does not return a result set (that means queries like UPDATE,INSERT,DELETE,CREATE). Use hk_exportxml or hk_exportcsv to execute 'SELECT'-queries. If you don't want to execute a predefined query, use --sql to add a SQL statement

Examples

hk_actionquery -d mysql -b exampledb myquery

hk_actionquery -d mysql -b examplequery --sql "SELECT * from authors"

Options

-b, --database=DATABASE: database name

-d, --driver=DRIVERNAME: set the SQL-driver (e.g. mysql). You can get a list of all existing SQL-drivers with -l or --list

-h, --host=HOST: name or IP-number of the host

-l, --list: List available database drivers

-p, --password=PASSWORD: user password at the SQL server

-r, --port=PORT: TCP-port on host

-s, --sql=SQL: sql statement that should be executed

-u, --user=USERNAME: user name at the sql-server

--version: version and author of hk_classes

Diagnostics

hk_actionquery returns 0 if everything was ok, or 1 if an error occured. A clear text error message will be written to stderr.

Releases

Unchanged in 3 releases since Debian 3.1 (Sarge).

3.1–5.0

Referred to by

hk_dbcopy(1) copies database elements between different database backends. hk_dbcopy is part of the hk_classes package hk_report(1) prints a report to stdout. hk_report is part of the hk_classes package hk_exportcsv(1) exports the result set of a query or a table into a comma separated list (CSV). hk_exportcsv is part of the hk_classes package hk_exportxml(1) exports the result set of a query or a table to a XML file. hk_exportxml is part of the hk_classes package hk_exporthtml(1) exports a datasource to a html file. hk_exporthtml is part of the hk_classes package.