sourCEntral - mobile manpages

pdf

SQLLINE:

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

pdf