NAME
bif-sql - run an SQL command against the database
VERSION
0.1.0 (yyyy-mm-dd)
SYNOPSIS
bif sql [STATEMENT...] [OPTIONS...]DESCRIPTION
Run an SQL statement directly against the database. If the statement is not given on the command line it will be read from stdin.
If the statement begins with "select" or "pragma" the results of the statement will be fetched and displayed. Otherwise the return value of the statement (DBI "do" method) will be printed.
By default a read-only handle for the database is used. Note that "pragma" statements would therefore require the --write flag to succeed, even if they are only returning data.
ARGUMENTS
- STATEMENT
-
The SQL statement text to execute. You will possibly want to use single quotes around this argument (or escape shell characters like "*") to prevent unwanted shell expansion messing with your query.
OPTIONS
SEE ALSO
bif(1)
AUTHOR
Mark Lawrence <nomad@null.net>
COPYRIGHT AND LICENSE
Copyright 2013 Mark Lawrence <nomad@null.net>
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 3 of the License, or (at your option) any later version.