| hk_actionquery - executes a query that does not return a result set. hk_actionquery is part of the hk_classes package |
| hk_actionquery -d driver -b database [OPTIONS] queryname |
| 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 |
| hk_actionquery -d mysql -b exampledb myquery |
| hk_actionquery -d mysql -b examplequery --sql "SELECT * from authors" |
| -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 |
| hk_actionquery returns 0 if everything was ok, or 1 if an error occured. A clear text error message will be written to stderr. |
| Horst Knorr <hk_classes@knoda.org> |
| hk_exportcsv(1), hk_exportxml(1), hk_importcsv(1), hk_report(1) |