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.