---
name: "hk_actionquery"
section: "1"
platform: "linux"
package: "libhk-classes-dev"
version: "0.8.3-4"
release: "Debian 5.0 (Lenny)"
platforms: ["linux"]
url: "https://new.carta.tech/hk_actionquery"
---

# hk\_actionquery(1)

executes a query that does not return a result set. hk\_actionquery is part of the hk\_classes package

## 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@knoda.org\>

## SEE ALSO

[**hk\_exportcsv**(1)](/hk_exportcsv/1.md), [**hk\_exportxml**(1)](/hk_exportxml/1.md), [**hk\_importcsv**(1)](/hk_importcsv/1.md), [**hk\_report**(1)](/hk_report/1.md)