hk_actionquery

NAME

hk_actionquery − executes a query that does not return a result set. hk_actionquery is part of the hk_classes package

SYNOPSIS

hk_actionquery -d driver -b database [OPTIONS] queryname

DESCRIPTION

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.

AUTHOR

Horst Knorr <hk_classes AT knoda DOT org>

SEE ALSO

hk_exportcsv(1), hk_exportxml(1), hk_importcsv(1), hk_report(1)