NAME¶

sqlline - JDBC command-line utility for issuing SQL

SYNOPSIS¶

sqlline [ option... ]

DESCRIPTION¶

-u <database url>

the JDBC URL to connect to

-n <username>

the username to connect as

-p <password>

the password to connect as

-d <driver class>

the driver class to use

--color=[true/false]

control whether color is used for display

--showHeader=[true/false]

show column names in query results

--headerInterval=ROWS;

the interval between which heades are displayed

--fastConnect=[true/false]

skip building table/column list for tab-completion

--autoCommit=[true/false]

enable/disable automatic transaction commit

--verbose=[true/false]

show verbose error messages and debug info

--showWarnings=[true/false]

display connection warnings

--force=[true/false]

continue running script even after errors

--maxWidth=MAXWIDTH

the maximum width of the terminal

--maxColumnWidth=MAXCOLWIDTH

the maximum width to use when displaying columns

--silent=[true/false]

be more silent

--autosave=[true/false]

automatically save preferences

--outputformat=[table/vertical/csv/tsv]

format mode for result display

--isolation=LEVEL

set the transaction isolation level

--help

display this message

Usage: java sqlline.SqlLine

-u <database url>

the JDBC URL to connect to

-n <username>

the username to connect as

-p <password>

the password to connect as

-d <driver class>

the driver class to use

--color=[true/false]

control whether color is used for display

--showHeader=[true/false]

show column names in query results

--headerInterval=ROWS;

the interval between which heades are displayed

--fastConnect=[true/false]

skip building table/column list for tab-completion

--autoCommit=[true/false]

enable/disable automatic transaction commit

--verbose=[true/false]

show verbose error messages and debug info

--showWarnings=[true/false]

display connection warnings

--force=[true/false]

continue running script even after errors

--maxWidth=MAXWIDTH

the maximum width of the terminal

--maxColumnWidth=MAXCOLWIDTH

the maximum width to use when displaying columns

--silent=[true/false]

be more silent

--autosave=[true/false]

automatically save preferences

--outputformat=[table/vertical/csv/tsv]

format mode for result display

--isolation=LEVEL

set the transaction isolation level

--help

display this message

-u <database url>

the JDBC URL to connect to

-n <username>

the username to connect as

-p <password>

the password to connect as

-d <driver class>

the driver class to use

--color=[true/false]

control whether color is used for display

--showHeader=[true/false]

show column names in query results

--headerInterval=ROWS;

the interval between which heades are displayed

--fastConnect=[true/false]

skip building table/column list for tab-completion

--autoCommit=[true/false]

enable/disable automatic transaction commit

--verbose=[true/false]

show verbose error messages and debug info

--showWarnings=[true/false]

display connection warnings

--force=[true/false]

continue running script even after errors

--maxWidth=MAXWIDTH

the maximum width of the terminal

--maxColumnWidth=MAXCOLWIDTH

the maximum width to use when displaying columns

--silent=[true/false]

be more silent

--autosave=[true/false]

automatically save preferences

--outputformat=[table/vertical/csv/tsv]

format mode for result display

--isolation=LEVEL

set the transaction isolation level

--help

display this message