Man Linux: Main Page and Category List

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_exportxml(1), hk_importcsv(1), hk_report(1)

                              hk_classes package               hk_exportcsv(1)