---
name: "hk_exportcsv"
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_exportcsv"
---

# 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

## NAME

hk\_exportcsv - 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

## SYNOPSIS

**hk\_exportcsv -d driver -b database \[OPTIONS\] datasourcename**

## DESCRIPTION

**hk\_exportcsv** exports the result set of a query or a table into a comma separated list (CSV). The data will be printed to stdout. To create a table or a query use **knoda (http://www.knoda.org).** If the datasource is not a table set the **--query** option.

## OPTIONS

- \-b, --database=DATABASE

  database name

- \--between=BETWEEN

  column separator, default is ','

- \-d, --driver=DRIVERNAME

  set the SQL-driver (e.g. mysql). You can get a list of all existing SQL-drivers with **-l** or **--list**

- \--delimiter=TEXTDELIMITER

  the text delimiter, default is '"'

- \--df=dateformat

  date format, may contain M D Y, example: D.M.Y

- \--tf=timeformat

  time format, may contain h m s , example: h:m:s

- \--dtf=datetimeformat

  datetime format, may contain M D Y h m s, example: D.M.Y h:m:s

- \--locale=locale

  locale of the export file, influences the number appearance

- \--charset=charset

  charset of the export file

- \-f, --filter=FILTER

  filter of the datasource. It has the same syntax as the WHERE clause of a SQL statement, just without the 'WHERE'. **Example:** "author\_id = 5"

- \-h, --host=HOST

  name  or IP-number of the host

- \-l, --list

  List available database drivers

- \--noheader

  if set the column names will not be included in the first row

- \-p, --password=PASSWORD

  user password at the SQL server

- \-q, --query

  if set the datasource is a query, not a table

- \-r, --port=PORT

  TCP-port on host

- \-u, --user=USERNAME

  user name at the sql-server

- \--version

  version and author of hk\_classes

## DIAGNOSTICS

hk\_exportcsv 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\_actionquery**(1)](/hk_actionquery/1.md), [**hk\_exportxml**(1)](/hk_exportxml/1.md), [**hk\_importcsv**(1)](/hk_importcsv/1.md), [**hk\_report**(1)](/hk_report/1.md)