run-db.pl - Run SQL
run-sql.pl "select * from mytable where 1=0" run-sql.pl --sql create-table.sql echo "select * from mytable where 1=0" | run-sql.pl
This sets up the database. The following options are recognized:
The DBI DSN to use for connecting to the database
The alternative SQL file to use instead of what is passed on the command line.
Output no headers for empty SELECT resultsets
Set the exit code to 1 if at least one result row was found
Output the (single) column that the query returns as a string without any headers
Use a different formatter for table output. Supported formatters are
tab - output results as tab delimited columns Text::Table - output results as ASCII table Text::Table::Any - output results as various formats
Don't stop on errors
Show this message.